Skip to Content
0
Former Member
Nov 03, 2008 at 09:32 AM

SSM KPI Security:Restricting the measures to Users

42 Views

Hi

I want to restrict only few KPIS(measures) to be accessed by a particular user. I was able to restrict only 22 measures(4 KPIs), beyond which i get an error.But this user should be able to access 20 KPIs(20*5 measures). The syntax that i used:

INDEX USER

CASE USER1

SELECT VARIABLES KPI59_ACT,KPI59_TAR,KPI59_TRD,KPI59_TARDEV,KPI59_TRDDEV,KPI20_ACT,KPI20_TAR,KPI20_TRD,KPI20_TARDEV,KPI20_TRDDEV,KPI58_ACT,KPI58_TAR,KPI58_TRD,KPI58_TARDEV,KPI58_TRDDEV,KPI57_ACT,KPI57_TAR,KPI57_TRD,KPI57_TARDEV,KPI57_TRDDEV,KPI2_ACT,KPI2_TAR,KPI2_TRD,KPI2_TARDEV,KPI2_TRDDEV

ENDINDEX

1. Is there any way that i can restrict the access to 20 KPIs (20*5 measures)?

I also tried the following syntax but of no avail:

For example here i tried restricting access to 3 KPIs(each of which has 5 measures:Tar,Act,Trend,Gap Performance,score)

SELECT VARIABLES KPI1_* , KPI21_* , KPI33_*

2. Is there a limit on the number of characters used in the select statement because of which only few measures were included in my case?