Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a scenario where Dynamic Reports has be created. Inputs Needed
Example
Dimensions:
Country
City
Branch
Measures:
YTD
YTDN-1
No of Customers
Thanks
Senthil Kumar P
Hi Senthil,
PFA.
I have modified the file sent by Jagan. You can make the columns conditional so that they will be shown only when intended.
Hope it helps!
Hi Senthil,
1) You need to create a data island: it means you will populate a table related to no other table of your model. let's create a Dimension table:
LOAD * INLINE [
Dimension
MyDim1
MyDim2
MyDim3
];
Do the same with the measure
2) You create a ListBox with that dimension, a LB with the measures
3) In the table:
a) create calculated dimensions
for the 1st one: = $(=SubField(concat(distinct Dimension, '|'), '|', 1))
b) Click Enable Conditional for this dimension: =(GetSelectedCount(Dimension) >=1)
The measure will be quite the same: sum($(=Measname)) or if you have entered directly the equation into the load script : $(=Meas_Equation)
This technique does not work too much with Set Analysis but it should wrk for you.
Fabrice
@ Shyamal Pandit
Thanks. But if i select the Dimension and Measures , Dimension is not visible in the Table and It is Not working if i select 2 Measures also.
If you want to use several measures, use the same syntax as for Dimension.
Enable the nth measure if you have chose more than N measures, the expression is quite the same as for the dimension.
Fabrice
Hi,
Please find updated file attached.
Regards,
Jagan.
Please find a QVW file and a XLS file used to create this QVW: the whole in Customer.zip
the QVW comes from a personal version but you should be able to open it.
Good luck
Fabrice