Print Page - Simple union query in dimensional source

Title: Simple union query in dimensional source
Post by: cognos05 on 17 Dec 2019 08:46:57 AM

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.

Title: Re: Simple union query in dimensional source
Post by: rockytopmark on 01 Jan 2020 01:36:12 PM

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

Title: Re: Simple union query in dimensional source
Post by: cognos05 on 01 Jan 2020 07:24:47 PM

Ytd and Last Month are from different hierarchies.

Title: Re: Simple union query in dimensional source
Post by: Francis aka khayman on 06 Jan 2020 11:02:43 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos05 on 17 Dec 2019 08:46:57 AM