cancel
Showing results for 
Search instead for 
Did you mean: 

Values mismatch in Inventory - issue with Fiscal quarter

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Thanks for the reply.

we've already tried to do the same. As you said only two quarters are coming but values are wrong.

This logic and values are coming fine in SD but this is happening in inventory only.

Couldnt able to understand what could be the issue.

Thanks

Jani

former_member182470
Active Contributor
0 Kudos

Have you missed my last reply?

Former Member
0 Kudos

HI Suman,

i've already done that putting fiscal quarter into rows directly..still no impact.

Thanks

Jani

former_member182470
Active Contributor
0 Kudos

Now I suspect again about the data relationships. Because the fields which you keep in row should definitely be in sync in terms of relationship(correspondence). If that is not happening in your case, there is wrong. Please analyze from your infoprovider level to Bex.

former_member182470
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hi,

I m sending the screenshots of stock values at info cube level and the routine at transformations level.

Please have a look.

Thanks

Jani

anshu_lilhori
Active Contributor
0 Kudos

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

former_member182470
Active Contributor
0 Kudos

Your data looks to be ok in the cube. I suggest you to keep Fiscal Quarter in rows instead of free chars to see how data comes in the report.

Keep Fiscal year, Fiscal year period, fiscal Qua in rows and check the data in report.

anshu_lilhori
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

Please find the attached screenshots for more details.

please have a look and suggest me on this.

Thanks

Jani

anshu_lilhori
Active Contributor
0 Kudos

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

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

wrong forum. i'm transfering you to SAP netweaver business warehouse / BEx . this space is for business objects,