hi,
I have 12 KPI’s in one XLF file. Now I am looking to provide user level security, such that user one can see 4 KPI’s , User 2 can see 5 KPI’s and so on so forth.
Any help?
Rakesh_K 
(BOB member since 2007-12-11)
What is your data source for your Xcelsius model?
If you can use SSO and pass on the security from SAP BW for example, meaning at time of refresh (of QaaWS for example or SAP Bex queries via BICS) the security kicks in and only data is retrieved, that the user is authorized to use.
Andreas 
(BOB member since 2002-06-20)
I am using QaaWS.
database: oracle 9i
Rakesh_K (BOB member since 2007-12-11)
Well, setup the appropriate security either at the database level (e.g. Oracle VPDs/Virtual Private Databases) or within BOE. The security will then “flow” into QaaWs (which is based on a universe) and the data retrieved will be limited by the user, who is logged in. Voila.
I cannot provide you with a detailed a step by step approach.
Andreas (BOB member since 2002-06-20)
That will be row level security. I want to implement security at dashboard level.
Rakesh_K (BOB member since 2007-12-11)
Incorrect, there is row-level security AND object-level security/column-level security.
Andreas (BOB member since 2002-06-20)
Andreas,
Like we can implement report level security through CMC. Can we do implement such security for dashboards also so a user can have access to particular KPI’s only not all the dashboard.
Rakesh_K (BOB member since 2007-12-11)
To show or not show a certain KPI depending on the logged-in user can be implemented via column-level security (I suggest to implement security at the DBMS level, see Oracle’s VPD for example).
If you want to show/hide certain components of your Xcelsius dashboard (such as certain charts e.g.) you will have to use the @BOUSER variable in conjunction with Xcelsius’ dynamic visibility. Or create separate dashboards alltogether,
That should get you started, good luck 8)
Andreas (BOB member since 2002-06-20)
Thanks Andreas. Worked fine. 
Rakesh_K (BOB member since 2007-12-11)