Simple union query in dimensional source

[cognos05]

Hi ,

I wanted to create one list report for excel export to user

Query should bring data for last completed month , YTD and PYTD

So I have my data items as Product level , FullRevenue,Budget and a slicer on 8 regions. For time period , I have 3 different members last month,YTD and Pytd .

How do i get this query .

If I do a union ,I am getting no data available.

[rockytopmark]

set([last month],[YTD],[Pytd])

[cognos05]

Ytd and Last Month are from different hierarchies.

[Francis aka khayman]

try gool old fashion query manipulation...

one query each for Month, ytd and pytd (if ytd and pytd are from the same hierarchies you can use one query for them)

then join or union the queries whichever appropriate