August 18, 2008 at 7:09 am
Dear Forumers,
I am having an issue with trying to create a report model using OLAP Cube as Data Source. I will explain the best of my ability. I am attempting to create MS Visual Studio 2005 solution for a report model to connect to an OLAP cube. I have no problem with creating the actual datasource. I select the Provider (Analysis Services 9.0) and InitialCatalog (Database that contain the cubes I want on the Analysis Server). The problem is when I attempt to create a data source view using the data source I created. Is their an alternative, if so, please explain step-by-step what it is. Thank you.
Mike Smith
August 22, 2008 at 2:41 am
Mike hi, I think you maybe using the incorrect toolset, for although Visual Studio provides options for generating models based on MSAS 2005 databases, it doesn't (or at least I couldn't get it to).
There are two ways you can generate a model; via your Reporting Services web site, or, use SQL Server management Studio and connect to Reporting Services.
Using SQL Server Management Studio;
Connect to Reporting Services and expand folders.
Right-click the Home folder to add a data source (the MSAS2005 database).
Once your data source is in place, right-click it and select Generate Model. That should do it.
Couple of things;
Check that your dimension attribute's InstanceSelection property is set to "DropDown".
Review the naming conventions used as these will be reflected in the model.
On the web site you can hide models from the list views if needed.
any way hope this helps, happy hunting.
Duncan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply