This discussion is archived
2 Replies Latest reply: Jan 31, 2013 6:28 PM by Srini VEERAVALLI RSS

the problem of  filter data in dimension

island_man Newbie
Currently Being Moderated
there are one security setting requirement, for example, a sales manger can only view the saler he managed. my solution is filter data in project owner dimension in BMM,
add the below code in the tab "where" of logic table source.
-------------------------------------
CASE WHEN VALUEOF(NQ_SESSION."groupRole") = 'salerManager'
THEN MarketCoverage.MarketCoverage.dbo.OppFact2.PRJ_OWNER_ID ELSE 'N/A' END IN ( VALUEOF(NQ_SESSION."List_of_Saler"))
------------------------------------------

now , in the dashboard, if the report has column has the dimension of "Project owner", then the data filter is all right .
but if the report has no column of "project owner", then it will show all data ,can't filter the data.

any one has comments? thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points