on 09-02-2013 10:44 AM
Hello,
I've a requirement of Inventory overview with respect to Fiscal year, Fiscal Quarter and Calmonth wise.
we've derived Fiscal Quarter from fiscal period.
Till cube level, data is coming fine.
In report, i've given selections for cal month: 04.2012 to 08.2012.
Fiscal year wise, Calmonth wise Goods issues, Goods receipts and Totals are correct but when we drill down the Fiscal quarter then values quarter wise wrong and it is fetching more number of quarters.
Like 004.2009, 001.2010, 001.2013...etc
Please have a look into the attached documents.
Please suggest me on this.
Thanks
Jani Basha SHaik
Hi Jani,
As per the screens u given, you are getting the correct result as a final value. Here you want to avoid the fiscal quarters not related this data.
For that you just create a variable or create a selection on fiscal quarter that has to be derived based on Fiscper (Give reference characteristic as FISCPER). So that remaining values will be ignored.
please let me know if you want some more info related to this issue/ you face other issue.
Regards,
Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It seems there is no relationship between Calmonth and Fiscal Quarter. As you are calculating Fiscal Quarter from Fiscal Period, this derivation is not in conjunction with Calmonth. This is your issue.
You need to make changes in your Cube transformations. There should be proper relationship between all three.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
There is nothing wrong with the data nor with the population of fiscal year quarter based on routine.
The only thing i can think of is that user input variable is based on 0calmonth ---is it in global filters like in characteristic restriction or local filter.
Please check that..Apply the filter in global area and drill down based on quarter and see what result it gives.
Regards,
AL
Hi,
I would suggest to make two quick checks.
First drill down the query based on fiscal year period to know the proper relation between calmonth and fiscal year period.
Second with the same restriction of clamonth check the data at cube level and see what values are getting populated in fiscal year period and fiscal quarter.
If possible share the screenshots of the same as well.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As per your stock screenshot i can see that fiscal quarter is not populated where stock value is 0.
Please check the same and also let us know the logic you used for calculating fiscal year quarter.
For fiscal year period 001.2012 to 003.2012 the fiscal year quarter will be 001.2012 correct.
004.2012 to 006.2012 FQ will be 002.2013
007.2012 to 009.2012 FQ will be 003.2012
010.2012 to 012.2012 FQ will be 004.2012.
check for this relation.
Regards,
AL
wrong forum. i'm transfering you to SAP netweaver business warehouse / BEx . this space is for business objects,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.