Data cubes: do star schemes work at all? [message #243072] |
Mon, 18 June 2007 07:40 |
No real name![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=eclipse%40l6n.net) Messages: 23 Registered: July 2009 |
Junior Member |
|
|
Hello again,
I am trying to set up a data cube with a star schema: a fact table with
the measure and ids of the dimension values, plus dimension tables which
hold names of the dimension values by the respective id.
1. Define a data cube with the fact table as primary table
2. Add the measure from the fact table as cube measure
3. Add the id of a dimension table as dimension and link it in the "link
groups" view to the proper fact id column
4. Repeat 2&3 for another dimension
5. Create a cross tab and add the dimensions and measures
This works, but now the report shows the ids of the dimension values in
the cross tab. Now I try to show the dimension value names instead:
- Go to the data cube, "edit" a dimension value and select the desired
"Display Field".
Re-running the report gives the JS-error "XXX" not defined, where XXX is
the name of the display column I choose. Interestingly, if that happens to
be "name", the report runs and shows the name of the table(!). I suspect
that the code evaluating the display name is bound to the table object and
not to the row object.
Does this seem to be a bug, or do I misunderstand how to use the cubes?
Cheers,
Olaf
|
|
|
Powered by
FUDForum. Page generated in 0.02737 seconds