Search
Search

# Variable Offsets-Bit Tricky

Dear Friends,

It is very surprise with variable offsets (0CalWeek) in my Query.

I have a query where I have 2 structures.

In Rows, I have 3 selections in structure and one characteristic. The three selections are Different Product Groups let say <b>A, B., C</b> and characteristic is <b>Product</b>. So the Products are listing in the report according to <b>A, B</b> and <b>C</b>.

In Column, I have a Key Figure structure where I have <b>Stock,</b> <b>Age</b> (in No. of Months). The stock and Age are displayed against to Product.

Apart from the stock and Age, The User want to separate the Product Ages in to 4 categories like <b><6 Month Age Product Stock, <12 Month Age Product Stock, <24 Month Age Product Stock, >24 Months Age Product Stock</b>. I created these selections using Boolean operators taking in to consideration of Age and Stock.

I have two variable selections for this query, <b>Country</b> (Mandatory) and <b>Cal Week</b> (Mandatory, User Entry/default). The <b>Stock</b> Key Figure is restricted with Variables <b>Calweek</b> and <b>Country</b>. Up to now the Report is working fine.

Now the User has new requirement is to calculate <b>Previous 12 weeks Sale</b> (in Units) of Product and then he wants to compare <b>Previous 12 weeks Sale</b> with each of <b><6 Month Age Product Stock, <12 Month Age Product Stock, <24 Month Age Product Stock and >24 Months Age Product Stock.</b>

To Calculate <b>Previous 12 Weeks Sale</b> I have <b>Actual Sales</b> as Key Figure in Cube. In Selection, I restricted sales with <b>0Calweek variable</b> with offsets and like that I made 12 selections. I created formula for <b>previous 12 Weeks Sale</b>.

Now my problem is When I introduced this <b>Previous 12 Weeks Sale</b>, The other columns <<b>6 Month Age Product Stock, <12 Month Age Product Stock, <24 Month Age Product Stock, >24 Months Age Product Stock</b> are not populating with Stocks but <b>Previous 12 Weeks Sale</b> is working fine.

If I remove <b>Previous 12 week Sal</b>es and all 12 selections then all the ageing Columns are working.

This is bit tricky, Please suggest me a suitable solution for this. Your help is highly appreciated.

Thanks,

SB

##### Former MemberMay 19, 2006 at 15:19 PM0 Likes
View more on this topic or