How to create Adhoc Reports

[#1]

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

[#2]

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!

[#3]

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

[#4]

@ 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.

[#5]

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

[jagan]

Hi,

Please find updated file attached.

Regards,

Jagan.

[#7 · Accepted solution]

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