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

[Behnamqmarsi]

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

[bdbits]

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

[CognosPaul]

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.