cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic selection of members

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

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

0 Kudos

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

former_member186498
Active Contributor
0 Kudos

Hi Rai,

if "one to many" then is ok with the solution gived by Shrikant put an account property in UserDefined dim and an entity property in Account dim and you will be able to filter the dimension values.

Regards

     Roberto