on 03-09-2015 7:48 AM
Dear members,
I have 3 dimensions
1) Entity dimension
2) Account Dimension
3) User Dimension
User requirement is that when it select Entity dimension member > Account Dimension members and User Dimension members automatically filter and only members linked by Entity are opened.
Entity members
E1
E2
E3
Account
Output1
Output2
Output3
User define
FC1
FC2
FC3
FC4
FC5
Following report is desired
Entity = E1
Account Userdefine
Output1 FC1
FC2
Output2 FC3
FC4
FC5
Output3 FC5
How the above report can be achieved.
Please reply.
Best regards
Hi ,
What the relationship between Entity - Account , Account to Userdefine ?
If it is one to one then create "Entity" property in Account, create in "Account" property in Userdefine.
And use "Dimension property" in edit report to pull related members.
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The combination is one to many as mentioned above Entity E1 has 2 Outputs and further on each output has several User define dimension's member. I tried it like you said but it made multiple combination of account and User define members rather to restrict it. Following is the result when i try to place filter on Account and Userdefine dimension.
Entity = E1
Account Userdefine
Output1 FC1
FC2
FC3
FC4
FC5
Output2 FC1
FC2
FC3
FC4
FC5
Output3 FC5
FC1
FC2
FC3
FC4
Now here the property filter is making combination with all the Accounts member rather than restricting it like desired report.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.