on 12-18-2008 3:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.