cancel
Showing results for 
Search instead for 
Did you mean: 

User Objects in SAP Universe

Former Member
0 Kudos

Hi ,

How i create user objects in BO SAP OLAP Universe.

for Example i have date field with like 12/02/2008.

now i want 2 fields like 2008 and Feb ..

i am getting error in report level when iam trying create one object with date format

thnx in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Important observations when creating the SAP based universe is that. It is based on the single query or the cube selected at the the time of connection creation.

Other limitation as observed at our end that key figures. Suppose a new measure to be created Average with Amount / Quantity key figures from SAP query. This new measure will give the error.

REPORT level calculation can be done by Variable and Formula editor of WEBI

Answers (1)

Answers (1)

former_member212749
Active Participant
0 Kudos

Hi Reddeppa,

As per my understanding what you had intended is that you have a Date Feild

11/02/2008

and you need to seperate this ..if it is so

you can use substr(date,1,4) in the report level.

so you can get 2 feilds one is the year and month.

Is this the one that you need.Let me know if i am clear to you.

Regards

Prashant

Former Member
0 Kudos

Hi,

All calculated members or calculated measures using MDX must return numeric values.

This is one of the major MDX limitations in SAP.

In your case, as you only want to return the Year it should work.

Didier