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.
| Author |
Topic |
|
sinclair
Starting Member
7 Posts |
 Posted - 2009-09-02 : 05:36:27
|
| I am learning Cubes using SQL Server 2008 / BIDS. Is it possible to create a dimension using an indexed view?I have created an indexed view and created a Measure using it, but getting error: "No dimension relationship exists. The measure group ... is not related to any dimensions". But I do not know how to create a dimension relationship to a view. |
|
|
sinclair
Starting Member
7 Posts |
Posted - 2009-09-03 : 04:53:57
|
| Found Solution:1. In "Data Source View" create a "Logical Primary Key" by right clicking on view in main panel2. If using a composite key - create a "New Named Calculation" by right clicking on view in main panelwhich is a concatenation of the columns making up the composite.The expression is in format:(Col1 + '' + Col2 + '' + Col3)3. From Project Menu / New Dimension /existing table / choose View / include Named Calculation just made if composite.--It's now available to be added through usual method:Right click in Dimensions / Add / View is now available to be added |
 |
|
|
|
|
|
use a View as a Dimension