AndiWindisch Tracker

Managing "Mobile Device Whitelist" by Script?

AndiWindisch — Thu, 07 May 2015 15:13:45 GMT

Hey together,

we are considering enabling Access to the Mobile BI App for our SAS Visual Analytics User.

We have several Information (e.g MAC address) about the iPad's our Companies uses for the Business users.

Is there a possibility to maintain (Import and / or Export) the device Information into the whitelist of the 'Mobile Devices' Section of SAS Visual Analytics?
Maybe we can make something like a normal ETL Job (we are using also SAS Data Integration ) for do this?
What are the possible Device ID's we can use (MAC or something else)?

We would prefer to make use of the 'Whitelist' and wish to automate the Maintenance...

As far i have read at 'SAS(R) 9.4 Intelligence Platform: Middle-Tier Administration Guide, Second Edition' there is no possibility describe, as to do this manually.
We have about 60 to 120 iPad in use, so this would be very time consuming way...

Best regards,
Andreas

Re: Strasse und Hausnummer trennen (split string in two variables)

AndiWindisch — Wed, 15 Apr 2015 10:46:13 GMT

Hallo Silke,

ich würde vorschlagen, dass mal mit den Perl Regular Expression (RegEx) zu versuchen.
Die Problemstellung gibt ja keinen festen Trennpunkt her, also muss man sich diesen ermitteln.

Der reguläre Ausdruck (\d) sucht nach einem numerischen Wert, die Funktion PRXMATCH gibt die erste Position zurück.

data example;

input street_number $30.;

datalines;

Limburger Str. 15a

Genter Str. 1

Schanzenstrasse 12 b

Hollunder Weg 92

;

run;

data _text(Drop=_sta _len);

set example;

_sta = prxmatch("/\d/",street_number);

_len = length(street_number) - _sta;

street = substr(street_number, 1, _sta - 1);

street_no = substr(street_number, _sta, _len+1 );

run;

Ergebnis:

Viele Grüße

Andreas

P.S. Informationen findet man auch in dem Perl Regular Expressions Tip Sheet

Re: Question on moving from SAS VA 6.4 to 7.1

AndiWindisch — Thu, 05 Mar 2015 09:42:31 GMT

Hy,

we did this in November 2014 on our distributed installation on Linux.
It was not a big issue, we did it as a upgrade.

As from upgrades in the past i think the most important thing is to ensure, that the LASR and Hadoop Installation is going correct.

Maybe you will create a SMU (SAS Migration Utility) for the metadate befor, additional to the normal metatdata backup.

Best regards,
Andreas

Re: How do you use SAS Theme Designer for Visual Analytics? SAS wants to know.

AndiWindisch — Mon, 23 Feb 2015 14:40:37 GMT

Hello Sheila,

i have tried to answer correctly and attach two screenshots of our custom design.

1.) On your team, who is responsible for working with SAS Theme Designer?

We are a very small Team, so that the admin is also the 'Designer', i used it by myself.

2.) How have you used SAS Theme Designer to customize the look and feel of the application?

I have used the 'SAS Light' theme as basis for developing a 'Badenia Light' theme, which is based on our Intranet-Design.

Especially we have changed the background colours and integrated our Logo.
So i did only very 'simple' customizations.

3.) Can you list out the elements of the UI that you’ve updated with your company’s brand content, e.g., company logo, etc.?

- change background Colours

- integrate Logo

4.) What aspects of SAS Theme Designer have been easy to use? Difficult to use?

I think the Theme Designer is easy to use with the WYSIWG - Window in the left.

5.) What capabilities would you like to see in SAS Theme Designer that don’t exist today?

Sharing/Editing Colouring schemas based on CI rules for the different Objects on Diagrams or buttons. And Publishing them for the end users.

Best regards,
Andreas

SAS Light as shipped:

Badenia Light

Re: I would like to know how to make fiscal year

AndiWindisch — Tue, 03 Feb 2015 08:16:56 GMT

Hi Ted,

thank you for your direct response. Adding something similar like the good INTNX - Function (as in Base SAS) would be a very great addition!

We have a lot of discussions with our colleagues of the financial department about different date calculations.

Regards,
Andreas Windisch

Re: Usage Statistics of VA Reports

AndiWindisch — Mon, 23 Jun 2014 07:21:03 GMT

Hi Michelle,

thanks a lot for your post, the paper is really very interesting, because it is "hands-on" with much suggestions for the implementation.

I think we will try this way to get mor information about the usage!

Best regards,
Andreas

Re: Usage Statistics of VA Reports

AndiWindisch — Mon, 23 Jun 2014 07:19:15 GMT

Good Morning Allan_dk,

that sounds quiet interesting, with the logging threshold. I guess it must be the Threshold of the Metadata Server, or is it another one?

Best regards,
Andreas

Usage Statistics of VA Reports

AndiWindisch — Fri, 20 Jun 2014 09:30:49 GMT

Hey Folks,

since last November we are working with Visual Analytics, since 7th May we have the newest Release 6.4.

We have created a bunch of reports, as it should be, everything is fine. In the last weeks we have developed a few jobs in Data Integration Studio to load the data marts automatically to VA.

Now my boss is asking if there a way to find something about the usage of the reports?

We have very similar questions around our WIKI, there is a Plugin for this purpose.

I've taken some deeper looks to the log files (standard configuration, nothing changed since installation), but there is nothing to find what helps.

Is there a easy way to get Usage statistics, to figure out how our internal customers (Accounting, Marketing department) use Visual Analytics?

Thanks a lot for your help!

Best regards,

Andreas

Re: Problem migrating to VA 6.4

AndiWindisch — Mon, 07 Apr 2014 09:17:55 GMT

Hey Bram,

we have some similar problems with our Update 6.2 to 6.3 .

As is can see there is a major change between TKGRid and Hadoop. In the 6.2 Installation thers is a TKGrid_2.1 and with 6.3 came up with TKGrid_2.4 and a new directory TKTGDat_2.4 (for text analysis). There are also changes on the hadoop installation between 6.2 and 6.3.

From my point of view you will have to ensure, that your installation is running quite all correct "versions", in all other cases you will have errors. I have just a short look at 6.4 but i think it comes with TKGrid_2.5.

Hope this helps...

Best regards,
Andreas

Nachricht wurde geändert durch: Andreas Windisch Have a look at <http://support.sas.com/documentation/solutions/hpainfrastructure/25/hpaicg25.pdf>

Re: SAS Environment Manager on SAS Visual Analytics 6.3

AndiWindisch — Tue, 11 Mar 2014 19:52:46 GMT

Hey Bram,

thanks a lot for your post. That's what I have expected, we must install the Environment Manager Agent on the other Blades.

Through your post I know what to do. Will have to talk with my installation expert because of the plan file.

Kind regards,

Andreas

SAS Environment Manager on SAS Visual Analytics 6.3

AndiWindisch — Tue, 04 Mar 2014 12:23:03 GMT

Hi,

we are running SAS Visual Analytics 6.3 on a distributed Linux Environment (SuSe Linux Enterprise 11) with four nodes.

I would like to see the work load, load average and so on of the worker nodes, but for now i will only see the head nodes data.

Is this a normal behaivor?

How could i install the necessary Environment Manager Agent on the worker nodes?

Is there a standalone installer available or something like that?

Thanks a lot in advance!

Best regards,
Andreas

Re: Using Period to Date Calculations

AndiWindisch — Tue, 04 Feb 2014 20:46:07 GMT

Hey Anna-Marie,

thanks a lot for sharing the paper! I have tried just a few possibilities of the "Aggregate Measures", it looks very helpful.

Best regards,

Andreas

How to set up a non-english Stop List for Text Analysis

AndiWindisch — Tue, 04 Feb 2014 19:09:07 GMT

Hey,

we are very new to SAS Visual Analytics and have just upgraded our environment to 6.3 .

I've tried to load another 'Stop List' for the Text Analysis Feature, which is came with 6.3.

But i have no sucess.

First i created the Dataset for the 'Stop List', with german stop words named GERSTOP and only one variable 'TERM'. I load it to the LASR Server, into the same folder and library where the data for the text analysis is.

That's how i understood the manuel (SAS(R) Visual Analytics 6.3: User's Guide), but i won't work. I always get a information on the Word Cloud that no 'Stop List' ist defined.

Does anyone knows what is wrong in this setup? Other features of 6.3 will work.

Thanks a lot for you help!

Andreas