Traditional web-based reporting with SAS BI tools

olap cube mdx query

Reply
Frequent Contributor
Posts: 115

olap cube mdx query

I would like to add a authorization for for people belonging to certain groups in a olap cube.
Needs to give authorization on both below org_id1 & org_id2. Also for org_name1 and org_name2 members on same group

1. In below dimension "dim1", org_id1 and org_id2 member values are equal to SMC group identifier values.

Dim1
---hier_id
-----org_id1
--------org_id2


Below MDX query is working fine as member name is equal to identity group.


generate(
Filter([Dim1].[hier id].[org id1].members,IN ([Dim id].CurrentMember.name,"SUB:Smiley FrustratedAS.IdentityGroups"))
,
ascendants([Dim1].[hier id].currentmember)
)

<!--CONDITION-->

generate(
Filter([Dim1].[hier id].[org id1].members,IN ([Dim id].CurrentMember.name,"SUB:Smiley FrustratedAS.IdentityGroups"))
,
Descendants([Dim1].[hier id].currentmember)
)

2. In same dimension "dim1", org_name1 and org_name2 member values are not equal to SMC group identifier values.
but these member values are sub string of identitygroup display name.

for ex: dimension member value is "Telecom", SMC group display name is "Global Business Telecom"

Dim1
---hier_name
-----org_name1
--------org_name2

So SAS Identity group identifier value is equal to org_id1 or org_id2 member values (i,e. orgid1 and orgid2 is equal to SMC IDENTITY group id),
but org_name1 or org_name2 member value is sub string of SMC identity group display name.


Can some one help me on above second query either by using string function to concatenate "Global Business" with member value, if so it equals to "SUB:Smiley FrustratedAS.IdentityGroup display name"
  or
any other way by having org_name1 or org_name2 member properties contain org_id1 or org_id2 in above second hier_name, if so will use "SUB:Smiley FrustratedAS.IdentityGroups" to identify of org_name1 value with org_id1 value etc.,

Ask a Question
Discussion stats
  • 0 replies
  • 867 views
  • 0 likes
  • 1 in conversation