| Data cubes: do star schemes work at all? [message #243072] |
Mon, 18 June 2007 03:40 |
Eclipse User |
|
|
|
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.24026 seconds
Home