Hello everybody,
i'm quite new in Cognos world.
I have to access to a MS Analysis Server 2005 and i want to write my MDX.
I've found out how to specify an mdx on a query and i tried with a simple one:
select
([TIME].[MONTH].children, [Measures].[Qty])
on columns,
([CUSTOMER].[REGION].children)
on rows
from [SALES]
where
([CUSTOMER].[CUSTOMER TYPE].&[11])
i have no problem executing this query in SSAS but in cognos i get only one Line with total (and no lines with regions)... in mdx query structure i see only axis0 available and no axis1: am i missing anything??
thank u all,
daniele
Hi Daniele,
Why would you want to do this? It seems to be a hugely complex way of trying to write reports, and is effectively bypassing all the ease and power of the Cognos 8 query engine.
Instead, why not just create a crosstab report, dragging in the Month level in your columns, Region level in rows and Qty as the default measure, then add a slicer filter containing Member 11 from the Customer Type level. Simple drag-and-drop like this should take seconds and is much easier than trying to code a specific MDX query and reuse it.
MF.