[Mondrian] Aggregate tables and column / nameColumn - how is it supposed to work
pmgalves at gmail.com
Tue Nov 10 07:12:32 EST 2009
How are aggregate tables supposed to work when we use the nameColumn
for a level that has <level name="[MyLevel]" column="id"
nameColumn="desc"... /> I noticed that RolapStar creates 2 different
entries: MyLevel (2) and MyLevel (Key) (3);
Problem: When the agg tables are created (per PAD suggestion) only the
mylevelid_Key column is created. This means the AggStar will contain
dimension (3), but when I create a query like MyLevel.Children it's
querying for (2); Result: fact table gets hit.
What am I missing?
ps: Should I be using nameColumn at all? What's the difference between
this as caption?
More information about the Mondrian