If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

random values in semi-aggregate measure in crosstab report

Started by kiran.timsina, 10 Jul 2013 03:59:09 PM

Previous topic - Next topic

kiran.timsina

I have two tables as:
1. On Hand- item/location/day/OH qty
2. Time Day- day/week_number/month_name/year

Join:
inner join on day

Dimensions defined:
Regular dimension- Year, Month_Name (I had to make them separate reg. dim. because the same month can fall under two years)
Measure dimension- OnHand (aggregate rule of oh_qty is defined to "last" for both "Year" and "Month_Name" reg. dim.)

Now, I try to make crosstab report year versus month. What I get is random weekly ending on hand(EOH) values. Sometimes I get EOH of week 1 as the EOH of that month and sometimes I do get EOH of week 4 as EOH of that month.
This( http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id8708usage_aggregation_properties.html) link says nothing more.

Any clue of what I am missing. Help me cognoise guys, as always!  :)

Edit: "first" aggregate rule is working though to get beginning on hand.