on 01-25-2005 5:14 PM
Hello,
I am currently working on some BW reports and want to use the "Current calendar month" variable (0CMONTH). I searched for it and activated it in BC and even found it in the MetaData Repository - but I have no idea how to use it in my query. In my InfoCube I got some time-related InfoObjects, e.g. 0CalQuart1 etc...some help would be highly appreciated
Thanks in advance,
Manuel
Hi Manuel,
You need to include that in ur infocube too. go to the maintainence of the cube and add the said time char to ur cube, then the time char is reflected in ur query too.
Hope it helps.
Mav.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mav,
thansk for your reply, sorry to say that it didnt really help me out The problem is that 0CMONTH is a Variable and not an InfoObject, thats why I cannot add it to the cube...
I somehow have to use it in the BEx Query Designer in combination with an SAP Exit, but I have no idea how - anyone else?
Manuel
Hi Manuel,
You'll find useful documents on BW exits in the following link:
In the <b>SAP BW InfoIndex</b> folder (section).
Regards,
Andreu
Roberto,
in fact I need the following: I got data for various months in my cube and want to get month-related, quarter-related and year-to-date related reports. Every data set in my cube has a month, quarter and year characteristic. The problem that I am facing is that BEx does not "know" the month/quarter for which I want to generate reports for.
Let me explain this with an example: the last data upload to the cube contains data from august 2004, thus it has a "08" as month, a "4" as quarter and a "2004" as year. Besides this data there are data sets from all previous months in the cube. When opening a report I want to display results for the current month (which must be august, even if I start the report in december) and aggregated data for the quarter 03 (the quarter before the current quarter) as well as for the months 01-08.
I cannot work with variables like 0CMONTH because they contain the current month (system date). Instead I need a routine or something like that which checks the data in my cube and identifies the last month/quarter/year for which data has been uploaded.
I hope this clarifies my problem and would highly appreciate any help on this issue.
Thanks in advance,
Manuel
Heike,
thanks for your help. I have installed the BC variable, but I am not familiar at all with function modules. So if anyone could point out where I have to look for the code of this module I would be thankful...:)
I am glad that there are only stupid answers, but never stupid questions - at least they say so
TIA,
Manuel
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.