Can anyone help me?
I've read the instructions on the following page
http://msdn2.microsoft.com/en-us/library/ms159118.aspx
about how to generate a report model from a cube.
I can set up the cube as a data source but when I look at the properties there is no option to "Generate Model".
I am running SQL 2005 DE SP2(CTP).
The option is just not there for me. Any ideas?
Thanks in advance
Thanks for the reply. I get the 'Apply', 'Move' and 'Delete' buttons but not the 'Generate Model' one.
Very strange?
The following conditions need to be satisfied for the button to be shown:
1) you must be using a shared data source
2) the data source must point to either a SQL server database, or a SQL Server 2005 Analysis Services cube, or if using SQL Server 2005 SP2 you can also use an Oracle data source.
3) you have read properties on the shared data source (you meet this condition it appears)
4) you have create model permission on the folder you're viewing from the data source from. This permission is in the Manage Models task; it is in the default Content Manager role.
Hope that helps,
-Lukasz
Thanks Lukasz.
I'm not too sure what the exact problem was in the end but when I tried it again it worked.
yayomayn
