Hi,
I have a database structered as star schema.
I have defined each table as a dataset so when i created a cockpit using that objects, I ended up in all my measures are in one dataset and all my attributes are on another datasets. I entered correct Associations between datasets.
But i can't draw any charts since i can't select two datasets in widget configuration window if i select fact dataset i will have no name attributes, if i select dimension dataset i will have no measure field to map to chart.
I can flat all dimensions to fact table using a view and set that view as a dataset but probably i will hit a performance problem then.
What should i do?