Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

One indicator that sums up on one dimension and Averages on another

3 posters

Go down

One indicator that sums up on one dimension and Averages on another Empty One indicator that sums up on one dimension and Averages on another

Post  gsp Mon Mar 03, 2014 8:40 am

Hi everyone,

first hello to all. Then, here is my problem. How to model into a star schema the business needs that poses one indicator X sums on dimension A and averages on dimension B, that this indicator X must be analyzed into a crosstab across dimension A and B.

Below and example of the crosstab :
One indicator that sums up on one dimension and Averages on another Screen10
Over Jan/Total Product it sums.
Over Product 1/Total T1 it averages

To me, the solution doesn't relies on the model. The X value is stored into the fact table as it is and one does hard code into the crosstab the proper aggregation function according to the crosstab's context. That implies that one cannot both use the automatic and native data drill capacities of the tool (namely Cognos) as well as its native aggregation funtions.

So is this a solution to you and is there another one except cubes ?

Thanks a lot for any help and suggestions of you

Hi to all from France

gsp

Posts : 2
Join date : 2014-03-03

Back to top Go down

One indicator that sums up on one dimension and Averages on another Empty Re: One indicator that sums up on one dimension and Averages on another

Post  nick_white Tue Mar 04, 2014 10:22 am

Hi,

do it in Cognos.

If you need to, for performance reasons, you can aggregate your measures up to a common level - in your example group by month and product - in your data warehouse but you wouldn't want to predefine report column/row summaries in your DB

Regards,

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

One indicator that sums up on one dimension and Averages on another Empty Re: One indicator that sums up on one dimension and Averages on another

Post  ngalemmo Tue Mar 04, 2014 1:53 pm

It is not a modeling issue. It is a reporting problem. As Nick suggests, you should be able to do this in Cognos.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

One indicator that sums up on one dimension and Averages on another Empty Re: One indicator that sums up on one dimension and Averages on another

Post  gsp Wed Mar 05, 2014 3:47 am

That's perfect.
Thank you all for your help and answers.

gsp

Posts : 2
Join date : 2014-03-03

Back to top Go down

One indicator that sums up on one dimension and Averages on another Empty Re: One indicator that sums up on one dimension and Averages on another

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum