topic Re: Field Parameters, Dynamic IsInScope in Developer

Field Parameters, Dynamic IsInScope

CyrillS — Tue, 26 Sep 2023 06:42:08 GMT

Hello everyone
I made a simple model to make my question clearer. I have two dimensions, Product & Customer and a fact table Sales.

I made a SalesParameter table, which is a field parameter with the two dimension ID's ProductID and CustomerID, renamed as Product and Customer.
I want to use this parameter as rows in a matrix and next to the current level i want the description of the current dimension. For this i created the measure description.
The picture below shows the default case which works fine.

But when the user wants to see the customer first, by clicking the Customer in the field parameter and then the Product, then it doesn't work.

Is there a way to achieve it that the description it doesn't matter in which order I select the field parameter?

Any help is greatly appreciated.
Thanks
Cyrill

Re: Field Parameters, Dynamic IsInScope

Anonymous — Tue, 03 Oct 2023 06:31:03 GMT

HI @CyrillS,

The switch true structures can store multiple conditions and correspond calculations.

AFAIK, it not suitable to use if they are multiple conditions can be match with these conditions and it only triggered the first matched condition.(from top to bottom)

If you want to show multiple conditions, I'd like to suggest use if statement to check these scenarios and stored these results to the variables and concatenate them to get merged results.

Regards,

Xiaoxin Sheng

Re: Field Parameters, Dynamic IsInScope

olinayras — Thu, 19 Sep 2024 20:45:05 GMT

Hello, @Anonymous

I'm trying to solve the same problem, but I haven't succeeded yet. I tried to do as you said, but from what I saw ISINSCOPE is cumulative. Any tips on how to do it?