Default Category

[andrer]

Hello everyone,

I am facing a challenge, where I am in need of assistance.
Here is the scenario:

I am using Powerplay cubes as the source for the majority of my reports. Something that I am trying to do, is to introduce the notion of a dynamic default member that is based upon user groups. That means, that when an end user comes in to a particular Cognos 8 report (one that is sourced from a Powerplay cube), we'd like to default the value that is shown for a particular dimension for that user. (i.e. if I am a principal of School ABC, once I go into one of the dashboards we are developing, this user would first see all data related to school ABC). The second challenge is that we are not trying to add a security component to the model, we simply want the default selection for the school dimension to be dynamic, and based upon the group that user belongs to, and the user should also be able to view any other category in the school dimension, if he so chooses.

Any ideas?

Thanks everyone,
Andre