Hi
i am trying to build an olap solution.
i have a table of transactions which is my fact table ,each transaction
is from a user.
A user can have 1 or more transactions.
i have a table of users with unique userId.
The system holds about 10,000,000 users.
i want to aggregate my data per user and due to the limit of 64000
children's in a dimension , i cannot do so.
do we have a solution for that ?

You need to determine additonal levels in dimension 'Users'.
Usually, I'm using 'Index' level, its value is the beggining (first letter)
of the users name.
Perhaps you could add levels like 'State', 'City' something like that?

MC


<shlomis (AT) gmail (DOT) com> wrote

Hello,
create the dimension with the help of the
Assistent and select the option for grouping (i guess)
and auto grouping

HTH
Jörg



"shlomis (AT) gmail (DOT) com" wrote: