SAP Disclosure Management MSOLAP mdx query

[Former Member]

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

[Marc_Kuipers · Accepted solution]

Hello Welcome

What happens when you execute the MDX directly in MS Management Studio ?

Does it give a result?

Thanks

Marc

[Former Member · Accepted solution]

Hi Marc,

It also doesn't return any values other than Null.

Sorry I forgot to include that test scenario.

regards

Welcome

[Marc_Kuipers · Accepted solution]

Hello Welcome,

Ok, it is obviously essential that the MDX returns data, otherwise DSM will also not retrieve anything.

I just tested this with BPC MS

1. I have an MDX that returns data

2. In DSM, create an MSOLAP datasource

3. Create a BriefingBook with the same MDX

4. Create a DataLink that uses this query from the BriefingBook

--> data is retrieved

Marc

[Former Member · Accepted solution]

Hi Marc,

Thank you for the example.

Once I added the where clause with the correct filters, the data came through.
I needed to put more details in the where clause as well as the correct syntax

regards

Welcome Nguza