xMII OLAP Query

[Former Member]

Hi All,

i have following problem.

usual OLAP query is like

select

on columns, [0CALMONTH].Members on rows from CUBE. you will not see the measure names as column names in the OLAP Query template result. as you know the names of Measures you put them as alias. now i have a equirement where Query is like select [0CALMONTH].Members on columns, on rows

from CUBE.

SAP VARIABLES

[CALMNT] including [200701]:[200710]

now the measures are part of first column and are given as NA. is there any way i can alias these or any known transform.

thanks and regards,

A Prashant Kiran

[salvatore_castro]

Prashant,

Try writing the Query this way:

SELECT [Measures].MEMBERS ON COLUMNS,

NON EMPTY [0CALMONTH].MEMBERS

DIMENSION PROPERTIES

[0CALMONTH].[<PropertyName>]

ON ROWS

from CUBE

You can also write the MDX in the SAPGUI environment using the transaction <b>MDXTEST</b> which will help you with the specific dimension property values.

Hope this helps.

Sam

_

[Former Member]

sam,

i was trying the same in MDXTEST all the values / months appear and also measure names appear. when i take this query to xMII OLAP Query template these vanish and NA or C000001.... will appear in their place.

C000001 C000002 C000003

NA

NA

this could have been simple manupulation if we are expecting result in fixed format. like

Jan07 feb07 mar07

measure 1

measure 2

but my query will be bit dynamic if user ask for values from Jun06 till May07

each time the column arrangement changes.

please let me know if some one has faced this earlier and has some solution.

Regards

A Prashant Kiran

[salvatore_castro]

Prashant,

The column names are not returned to xMII due to a limitation in the BI XML/A interface which does not return them. As a result we have a column mapping tab in the template which can be accessed via JavaScript or BLS to set the column alias names. Unfortunately via XML/A these are your only options.

Sam