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

[Closed]Multiple aggreg[ate rules

Started by mrcool, 15 Jun 2010 12:18:43 AM

Previous topic - Next topic

mrcool

Hello All...

I have a query  on aggregate rules. Please Let me know if anyone here faced this before.
I have created a dimensional model and one of the fact is having multiple aggregate rules applied across dimensions.
here is how it is:

Fact A: Measure:XYZ: aggregate rule "Last" on calendar1 , aggregate rule "Last" on calendar2 ..like this I have couple of dimensions.

I have total of 7 different calendars.
In the reports when I am trying to pull the measureXYZ and one of the attribute from calendar1 , the query which cognos is generating(In report studio) is weird.
I am seeing all the dimensions(With out adding to query) in the query which have been defined in aggregate rules of the fact. This is really eating up the performance.
Let me know if you need any further information on this. Any help would be highly appreciated.
Cheers,
Mrcool

mrcool

Hi All...
Waiting for your reply  ???

mrcool

Using of alternate hierarchy solved my problem...