cancel
Showing results for 
Search instead for 
Did you mean: 

Linked property dynamic?

former_member225916
Participant
0 Kudos

Hi All,

How to make "Linked to Property" as dynamic( How to change it from sheet)??

I have a scenario where i have to override Linked to Property based on user selections.e.g. Product dimension has 2 properties ABC and XYZ. When user select Category A as selection then Product dimension should linked to ABC property. If user selects Category B as selection then Product dimension should linked to XYZ property.

Thanks & Regards,

Naidu

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Naidu,

Can you explain what do you want to achieve? What do you have in ABC and XYZ properties?

Vadim

former_member225916
Participant
0 Kudos

Hi Vadim,

Actually I have 2 properties in Product dimension (ABC and XYZ). These 2 properties contains the values of other (region) dimension values.

I have both product and region in row axis of my report and region is deriving from product property ABC using "linked to property" functionality.

Now the scenario is, i have category dimension in selection. If i select Category member "PLAN" then the linked to property value has to change to "XYZ" else if i select "FORECAST" then linked to member value has to change to "ABC". ultimately i have to change linked to property value dynamically....

Regards,

Naidu

former_member186338
Active Contributor
0 Kudos

No, this is not possible!