ARM logging to a sas dataset?

[dfs888]

Hi,

Does anyone know how to create a sas dataset from an ARM log?

I don't think running the %armproc and %armjoin macros alone will do it.

Thanks.

[LinusH]

What version are you on?

I think from 9.3, this will wok almsot "out of the box", at least with some standard logging.

I couldn't fins any documentation of the data model, but I think it would be quite easy to figure it out by examine log files.

[shivas]

Hi,

Check this links ...Hope it helps..

http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002171886.htm

http://support.sas.com/documentation/cdl/en/armref/61526/HTML/default/viewer.htm#a003282868.htm

Thanks,

Shiva

[dfs888]

Thanks Shiva and Linus. I am using SAS92.

It looks like I'll need to get more detailed information from the arm logs than what the default provides. Using the macros ARMPROC and ARMJOIN did consolidate the log entries, but it's very basic information.

[RMP]

Just curious dfs, what kind of information are you looking for?

[dfs888]

I was looking for details on what users are 'doing' in the olap cubes. that is, what cubes are they accessing, what they are querying, how long it takes, etc.

[shivas]

Hi ,

Are you looking for some thing like SAS OLAP SERVER monitor(which is in SAS MC).It provide details like

Session Name

is generated when the session is established.

Session Owner

identifies the user that started the session. If the server is not secured, the displayed value is <unknown>.

Seconds Inactive

displays the time in seconds since the conclusion of the last query.

Size

displays the combined size, in bytes, of the result sets that are open in the session.

Result Sets Open

Thanks,

Shiva

[dfs888]

Yes, the monitor information seems helpful, but i would need a report generated from the sessions. Also, i don't know if i have the proper permissions on the Console.