Hi All,
I created a datasource in ms sql server and imported the metadata which is having the relationships. So I want to know whether it is necessary to create a star schema of the imported tables or should I directly create a package and publishes it
Yours suggestions is appreciated.
Thanks in advance
It depends..
Are you importing a perfectly modelled starschema? Do you want to add calculations, do you want to change dataitem names?
Best practice would be to use a modelling layer to insulate changes between imported objects and those used for reporting