Dynamic reports visible Measures field

[#1]

Hi,

I have implemented Dynamic reports, and for selection of Measures I am loading fields from an excel sheet.

Now my question is can we load concatenated variable with column values in excel sheet. Ex

%Measures	%Measures_Flag
Units Growth vs 3 Last  Month	9
Units Sold  Last Month	10
Units Sold Last 2 Month	11
Units Sold Last 3 Month	12

In above table I want 'Units Sold Last Month' as 'Units Sold '& $(vPreviousMonth) &' Month', thus it shows as 'Units Sold Jan Month '.

I know we can do this with if condition in load, but as we have multiple Measures thus we will end up with multiple conditions.

Regards,

Navdeep

[#2]

Any help is really appreciated.

[satishkurra]

Hi

Please find the below approach.

Step1: Modify your script as below

SET HIDEPREFIX='%';

LOAD * Inline [

%Measures,%Measures_Flag

Units Growth vs 3 Last  Month, 9

Units Sold  Last Month, 10

Units Sold Last 2 Month, 11

Units Sold Last 3 Month, 12 ];

LOAD * Inline [

ID, Quantity

1,100

2,200

3,300 ];

Step2:

Create Chart (Straight Table) - ID as dimension and expression as Sum(Quantity) and now check Conditional and specify the expression as below

=SubStringCount(Concat(%Measures_Flag,'|'),10)

Step3: In chart properties of general tab, specify as

=GetSelectedCount(%Measures_Flag) > 0

Step4:

Now get %Measures Flag to the presentation layer and select 10, you can see the graph populated