Ad Hoc Report

[umartareen]

Hi All,

How can I generate an adhoc report without having two different tables for Dimensions and measures in the backend ?

Regards

Umar

[jjordaan]

Hi Umar,

You can try it with comparative analysis (available since version 11).

See this small tutorial http://www.youtube.com/watch?v=YVy0DE51z5M

Hope this helps.

[#3 · Accepted solution]

If you want to load only 1 table instead of two tables, try using Join to make as single table.

If you want to display the data, then you can use Table box or straight table to display them.

Thanks,

Sai

[umartareen]

Cool ! thank you Sai !

[umartareen]

Hi Jeroen,

Can we create Ad Hoc reports without using inline tables ?

[jjordaan]

Hi Umar,

Sorry for my late response.

I have never tried it but I don't think you can.

The reason is you need to create a table where your metrics are stored