Error while running Webi report that uses Custom Dimension object(SAP BW)

[Former Member]

Hi,

I have a universe that is based on SAP BW.I have created a custom dimension object that displays the maximum date.

The object syntax is

<expression>Max(@Select(CPS Online\Calendar day))</expression>

The object parses successfully.

The object 'Calendar Day ' is a defaultobject created during universe creation from the BW query.It is defined as [0CALDAY].[LEVEL01]

I tried to create a Webi report using this object and a measure .On running the query it throws the following error:

A database error occured. The database error text is: The MDX query WITH MEMBER [Measures].[EBC10672-C0DA-4998-93,80,D3,FF,C3,E8,A2,22] AS ' Max{[0CALDAY].[LEVEL01]} ' SELECT { [Measures].[EBC10672-C0DA-4998-93,80,D3,FF,C3,E8,A2,22], [Measures].[4JCOSFOKKCUR3RMBPNROFKQQD] } ON COLUMNS , NON EMPTY [0CALDAY].[LEVEL01].MEMBERS DIMENSION PROPERTIES [0CALDAY].[20CALDAY] ON ROWS FROM [ZCCPSONL/ZCPSONLINE] failed to execute with the error Invalid MDX command with (. (WIS 10901)

I have tried every possible syntax I could think of but I keep getting this error each time.I have set the object type to Number (even though it is actually a Date), I have tried writing the MDX inside the Max instead of the @select , but nothing seems to work.Could anyone please let me know why this error is occuring?Is there anything wrong with the syntax or is there any setting in Webi needed before a custom dimension object can be used on it.

[former_member142702 · Accepted solution]

Have you tried to declare the object as measure?

Stratos

[Former Member]

Hi,

The underlying BEx query has not been altered and hence the error cannot have been caused due to Universe Refresh.Have tried it though but the error still persists.

The measure objects that I am using in the uqery are all default objects(created directly from BEx query).The only custom object is the dimension object.All the objects parse at Universe level.The error still occurs at the Webi level while running the report.

Thanks and Regards,

Smitha.

[Former Member]

Hi Smitha,

The MDX syntax is case sensitive:

 <expression>Max(@Select(CPS Online\Calendar day))</expression> 

so I would suggest you to change the syntax and then try:

 <EXPRESSION>Max(@Select(CPS Online\Calendar day))</EXPRESSION> 

Also, I think that the Max() function in OLAP universe accept Numeric Expression as can be seen from the syntax.

Regards,

Rohit

[Former Member]

Can you see data for Custom object @ BEx level??

YES, then just try to re-create the same variable and Save the BW query.

Now do View - refresh Strusture @ Universe. And you can see Filter for the same, just Parse it, just whether it is OK or not.

OK -- then Export the Universe and create WebI reports, this will come as Prompt.

Hope it will helps you.

Thank You!!

Sent from iPhone

[Former Member]

Hi,

Due to some release date conflicts it is not possible to make changes to the BW query.That is why it is necessary to create the custom object in the universe.Does anyone have any suggestions to solve the error?

Thanks and Regards,

Smitha.

[Former Member]

I tried to create a Webi report using this object and a measure .On running the query it throws the following error:

>> Only two objects?? Can you drag few dimensions also and see...,

As you said, Max Date is parsed @Universe, can you did it for Measure objects?? Do Integrity Check @ Universe, to know is there are parse failed objects.

(Suggested as you have no access to do them @ BEx query level)

Thank You!!

Sent from iPhone

[Former Member]

Hi , i got this message when i change something in BI query and i dont refresh structure in Universe Designer, did you try to refresh structure?

Regards

[Former Member]

Hi,

I had tried converting it to a measure and also tried making it a numeric type.

The object parses (as always) but the same error occurs while running the report.

Could this error have anything to do with the syntax of the MDX statement.My basic requirement from the custom object is that it should return the maximum date when used in a report run with a prompt for date range.

Thanks and Regards,

Smitha Mohan.

[former_member142702]

We don't you use a local WebI variable for this?

Regards,

Stratos

[MariannevL]

An expression can only be numeric, it is treated as a keyfigure by BW.

You could get away with the key value of the date, which is yyyymmdd in a numeric format.

Then recast it as a date in the report.

Hope this helps,

Marianne