Report Builder Model Against Analysis Services Database
Hi,
I was just trying out the Report Builder Model that gets generated from the Analysis Services Datasource deployed on the report server where I realised it is not showing up one of the dimensions in my cube.I have a dimension in the cube which I created from
the currency conversion wizard in SSAS which is missing in the entities list.Any reason why?
Regards,
Vikram
January 24th, 2011 9:19am
Hi Vikram,
Make sure the dimension table has logicial primary key since it is a named query in the DataSource view, and connect with other tables using the keys.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2011 2:00am
Will try this and let you know.
January 25th, 2011 9:15am