Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 trouble adding standard dimension, missed step?

Author  Topic 

tybaltzeke
Starting Member

28 Posts

Posted - 2010-04-14 : 12:16:37
I went through the following steps the dimension shows up in solution explorer but not when i browse – am I missing a step?

Create the table
Create the view on the table
Connect the view to the fact table in the DSV
Run the dimension wizard, from existing view, select that view
The dimension wizard seems to run through all the steps successfully. The new dimension shows up in solution explorer

BUT

I cant process the dimension from solution explorer (right click the dimension, and click process), I get the error message
The Dim Legal Entity was not found in the AS_Production DB on the “ server
The dimension doesn’t show up in the browser or in dimension usage

What step am I missing?
   

- Advertisement -