Skip to Content
0
Former Member
Sep 22, 2016 at 10:14 AM

SAP Disclosure Management MSOLAP mdx query

22 Views

Hi SAP DMS experts,

I have created an MSOLAP connection to my SAP MS BPC 7.5 OLAP cube. The connection works fine.

The challenge I have is that the MDX query I have created doesn't return any values accept nulls. I have verified with the BPC team that there is data available.

my selection is as below:

SELECT

{

[Move_type].[H1].[MT_1],

[Move_type].[H1].[MT_2],

[Move_type].[H1].[MT_3],

[Move_type].[H1].[MT_4],

[Move_type].[H1].[MT_5],

[Move_type].[H1].[MT_6]

} ON COLUMNS,

{

[Item].[H1].[AS0566],

[Item].[H1].[AS0567],

[Item].[H1].[AS0568]

} ON ROWS

FROM [BPC OLAP cube]

We are on SAP DMS version: 10.1.5 sp 5

Your input will be greatly appreciated.

regards

Welcome