Print Page - How I create a cube has a dimension with too many members?

Title: How I create a cube has a dimension with too many members?
Post by: Behnamqmarsi on 16 Jan 2017 03:01:09 AM

hi
Greetings to all friends

I need to create a cube for banks. But account dimension has 80 million member.i do not how to bulid power cube
Please, if possible help me in this case

thanks

Title: Re: How I create a cube has a dimension with too many members?
Post by: bdbits on 16 Jan 2017 10:24:37 AM

And how many facts? Are you certain Transformer cubes are the proper solution?

Title: Re: How I create a cube has a dimension with too many members?
Post by: CognosPaul on 16 Jan 2017 11:20:25 AM

Cubes are better for aggregated data. I'd suggest making two solutions - a true OLAP for aggregated data and a DMR for the granular level. Any cube you try to make with 80m leaf keys will explode in size and just not work well.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: Behnamqmarsi on 16 Jan 2017 03:01:09 AM