where to find active clients

[wang_chris]

In which system cube, can I find active clients name and number?

The information can be found by admin in security -> clients/groups -> status. But it's hard to number active clients in this screen. If the information can be found in an internal cube, we can make an form to get the information from internal form, and sum active clients number.

Regards,
Chris

[lotsaram]

In which system cube, can I find active clients name and number?

The information can be found by admin in security -> clients/groups -> status. But it's hard to number active clients in this screen. If the information can be found in an internal cube, we can make an form to get the information from internal form, and sum active clients number.

Regards,
Chris

In tm1s.cfg you need to have the setting ClientPropertiesSyncInterval set to the value in seconds which the client status "active" property should be updated in the ClientProperties cube. Usually I have this set to 120 or 300 for update every 2 or 5 minutes.

Then all you need is a dynamic subset in the Clients dimension looking at the status in ClientProperties

Code: Select all

{FILTER( {TM1SUBSETALL( [}Clients] )}, [}ClientProperties].([}ClientProperties].[STATUS]) = "ACTIVE" )}

Another useful dynamic subset in the Clients dimension is the current user.

Code: Select all

{StrToMember("[}Clients].["+USERNAME+"]")}

[wang_chris]

added in my system.

Thank you for advise.

Regards,
Chris

[st2000]

Another useful dynamic subset in the Clients dimension is the current user.

Code: Select all

{StrToMember("[}Clients].["+USERNAME+"]")}

Thank you, very nice. But I have to admit that I'm wondering, what kind of syntax the part USERNAME is. I don't find it somewhere in the manuals. Is it a synonym of the TM1User-function? Or belonging to MDX? Is there more of that stuff, maybe documented somewhere?

[tomok]

USERNAME is an MDX function to return the name of the user executing the query. IBM doesn't include MDX keywords and functions in their docs.