on 09-16-2008 6:54 PM
Hello
I am loading a cube from the LO datasource for sales order item 2lis_11_vaitm.
I need some extra fields like fiscal year, fiscal quarter, etc. Do I have to enhance the datasource with these fields or can I just add it to the cube in BW?
Thanks
Adi.
there should be a way to get the data for those fields in the cube.
so even if you add in the cube you still need to have it in the underlying source which in your case is the datasource.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First you need to decide on a date on which your time charecteristics need to be based.
This is generally done as per spec(after discussion with customer/end user who asked for the report)
Besides this you will also need the field PERIV(Fiscal Year Variant) which is already present in the data-source 2lis_11_vaitm.
Add all the time charecteristics in the cube.
Next just connect the date and periv to the time charecteristic.
This should work for you.
If it doesnt you will need to write a routine and pass the date and fiscal year variant to an FM(check links on earlier post).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
for calculating fiscal year, fiscal quarter etc. in Cube you can use some function modules:
e.g. DATE_TO_PERIOD_CONVERT or FISCPER_FROM_CALMONTH_CALC
/thread/364138 [original link is broken]
If you cannot get your fields by calculation or formula in transformation you have to enhance the DataSource. Here are some useful links:
Regards
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.