Link for showing logged in users?

[image2x]

Someone had written a TM1 Excel "dashboard" which shows logged in users as red/green indicator lights.

I'm come across it before but I can't find it after 15 minutes of googling. (edit: make that 1.5 hours of googling...)

Thanks,
-- John

[image2x]

Giving this a bump.

I know I had come across this before somewhere and could really make good use of it.

It was an Excel spreadsheet that you'd manually list (I'd guess) your tm1 user accounts and it provided a red/green status light for when they were logged in.

[Alan Kirk]

Giving this a bump.

I know I had come across this before somewhere and could really make good use of it.

It was an Excel spreadsheet that you'd manually list (I'd guess) your tm1 user accounts and it provided a red/green status light for when they were logged in.

I think I know what it was; I recall seeing it before but I wasn't able to find it in my archives. It was in effect a riced up slice of the }ClientProperties cube. I can't recall whether the one I saw did this, but you don't need to manually list the clients; you could just use a series of DimNm functions to dynamically select the members of the }Clients dimension.

The problem is that the cube values aren't always reliable, especially if there's been a server crash recently.

I'm just about done with a workbook which uses the API (which does return the correct values) to do this, plus a couple of other features but I've hit some minor stumbling blocks (possibly bugs) and am waiting for a (useful) response from Iboglix. (I've had responses, but not particularly useful ones.) Actually the client list part already works except for returning the number of ports that each client is using (I've got the number for the server in total) but apparently that's one little (blindingly obvious) feature that someone forgot to implement in the API. (But, I'm told, I can raise an enhancement request. And if I'd like to hold my breath and am immune to asphyxia...)

[lotsaram]

You might be referring to this?

I don't take credit for it, I think this file was originally posed on the old forum by Eric.
(These days I wouldn't bother with all the effort, much easier to just take an active form slice from }ClientProperties and add some formatting)

NOTE: for this to work in 9.1.4 and all versions of 9.4 and 9.5 you will need to make sure the ClientPropertiesSyncInterval parameter in included in tm1s.cfg

[image2x]

lotsa, yup that was it... I searched forever for that.

Unfortunately, it still looks like I'm SOL. We're using CAM authentication and it doesn't appear that the status flag is maintained at all in }ClientProperties. Or this is a sign of the unrealiabiilty of this data as Alan mentions.

Alan, it's amazing how the simple, little things seem to get missed in big releases. My most recent favorite (read utter disappointed amazement) was the inability in 9.4.1 to paste data into web views (my workaround was a http upload script for users who could then launch a process to load their templates -- mind you with no security as I'm pretty sure processes dont' respect the security of the user who initiated them? never had time to test...)

Anyhow, do you believe the API would/should return valid user status even for CAM mode? I'll volunteer to test out the client status part of your code if you ever get a response back. Maybe by summer I'll have to chance to look at the API stuff.

Btw, what's Iboglix? A google search returned basically zilch.

Thanks to you both.

[Alan Kirk]

Alan, it's amazing how the simple, little things seem to get missed in big releases. My most recent favorite (read utter disappointed amazement) was the inability in 9.4.1 to paste data into web views

{Iboglix Development Guy With A Puzzled Look} "Why would you want to do that? We don't teach you to do that in our certification courses!" {/Iboglix Development Guy With A Puzzled Look}

Anyhow, do you believe the API would/should return valid user status even for CAM mode? I'll volunteer to test out the client status part of your code if you ever get a response back. Maybe by summer I'll have to chance to look at the API stuff.

That's an interesting question. The API code itself should since it's just reading straight from the internals of the server, but I'm not sure whether the function that piggy-backs off the client's connection will. Well, we'll soon see. One way or another I'll try to finish it off this weekend and you can have a play with it.

Btw, what's Iboglix? A google search returned basically zilch.

Kind of an in-joke dating back to the takeovers of a few years back. It's a combination of IBm, cOGnos and applIX, although you'll see less and less evidence of Applix's old practices these days. It's shorter than typing "Cognos An IBM Company" as they liked to be referred to in the early days of that particular takeover.

[vaneagle]

You might be referring to this?

I don't take credit for it, I think this file was originally posed on the old forum by Eric.
(These days I wouldn't bother with all the effort, much easier to just take an active form slice from }ClientProperties and add some formatting)

NOTE: for this to work in 9.1.4 and all versions of 9.4 and 9.5 you will need to make sure the ClientPropertiesSyncInterval parameter in included in tm1s.cfg

Does that fix it?

I was told the way it was setup that the data or whatever the spreadsheet looked at was dropped from 9.1 and never put back in...

I will have to try it at work tomorrow.

[lotsaram]

Unfortunately, it still looks like I'm SOL. We're using CAM authentication and it doesn't appear that the status flag is maintained at all in }ClientProperties.

For updating of the Status flag in }ClientProperties with ACTIVE I don't think it matters how a user is logged only whether the user is logged in. However like I said in order for this flag to be updated you must add ClientPropertiesSyncInterval to the tm1s.cfg file. For example:
ClientPropertiesSyncInterval=60
Including this parameter will enable a housekeeper thread which will wake every 60 seconds and update the status flag with either ACTIVE or a blank string for all clients.

As for the issue of not being able to paste into a 9.4 websheet, hadn't ever tried it until just now, but wow fairly unbelievable omission. Have you logged an enhancement request? I can confirm that paste into a websheet works just fine in 9.5 (which is just as well, it is hard to imagine how the new contributor client would work if this wasn't the case.) In terms of a work around though; wouldn't it be easier to just design a simple websheet interface for the users to input data into rather than a flat file load? (copy/paste does work with 9.4 websheets and with an active form slice you can do pretty much anything that you can do in the cube viewer.)

To Vaneagle, yep ClientPropertiesSyncInterval fixes it. This was introduced in 9.1.4 and has remained in 9.4 and 9.5. It is written up in the 9.1.4 release notes and you can also find it in the list of tm1s.cfg parameters in the operations guide in 9.4 and 9.5. The only version for which updating client status is truly unfixably broken (without a tm1top or API workaround) is 9.1.3. Although note that you might not want the update to be as frequent as every 60 seconds as per the example above if you have a lot of users. Every 5 to 10 minutes is probably sufficient for most purposes.

[image2x]

However like I said in order for this flag to be updated you must add ClientPropertiesSyncInterval to the tm1s.cfg file. For example: ClientPropertiesSyncInterval=60

duh... I missed that qualifier. I will try this parameter...

As for the issue of not being able to paste into a 9.4 websheet, hadn't ever tried it until just now, but wow fairly unbelievable omission. Have you logged an enhancement request?

Yeah, it was a big one to miss. I'm hoping it's "fixed' in FP3.

In terms of a work around though; wouldn't it be easier to just design a simple websheet interface for the users to input data into rather than a flat file load? (copy/paste does work with 9.4 websheets and with an active form slice you can do pretty much anything that you can do in the cube viewer.)

The problem is copy/paste performance in Websheets. We've got a boat load of users who need to paste a ~1400x12 grid of values which, for all practical purposes, is not possible in TM 9.4.1 (and I'm guessing is still true in 9.5). Cognos Planning had a data load wizard which clients could run to handle volume entries.

[Alan Kirk]

Someone had written a TM1 Excel "dashboard" which shows logged in users as red/green indicator lights.

I'm come across it before but I can't find it after 15 minutes of googling. (edit: make that 1.5 hours of googling...)

In addition to the replies shown above, see this thread.