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

Summary values differ from frame work and report studio

Started by tgs728, 05 Jun 2014 04:35:46 AM

Previous topic - Next topic

tgs728

Hi,
i have a query subject with the below columns Store_region,store_account,Total_sku,day_key and which is joined to time dimension with day_key i am getting the correct results as expected in Fm but when i drag the same columns with Store_region,store_account,Total_sku,[timedimension].[date] i am getting the wrong results my values are summed for store account and showing this is wrong.

When i put auto group and summarize property it is showing correctly.

Can i know what is the mistake in the report structure is there any work around with determinants.

Thanks,

TGS