dbTalk Databases Forums  

views

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss views in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Renzo Pamo
 
Posts: n/a

Default views - 08-09-2005 , 12:31 PM






Hello.
I have a problem with views.

I create a view of a table dimension.
I create a share dimension from this view.
but
if i edit a cube and want add this share dimension,
i dont can do , because dont show me in existing dimesions

thanks you

Reply With Quote
  #2  
Old   
Imtiaz Ullah
 
Posts: n/a

Default Re: views - 08-10-2005 , 07:01 AM






Try to refresh your data source or database and exit and re-open Analysis
Services Console.
Immy

"Jéjé" <willgart (AT) AAAhotmailBBB (DOT) com> wrote

Quote:
does your shared dimension is on the same database as your fact table?


"Renzo Pamo" <RenzoPamo (AT) discussions (DOT) microsoft.com> wrote in message
news:848212CC-F569-46C0-8E2A-D7857784AA61 (AT) microsoft (DOT) com...
Hello.
I have a problem with views.

I create a view of a table dimension.
I create a share dimension from this view.
but
if i edit a cube and want add this share dimension,
i dont can do , because dont show me in existing dimesions

thanks you




Reply With Quote
  #3  
Old   
Renzo Pamo
 
Posts: n/a

Default Re: views - 08-10-2005 , 09:25 AM



Thank you Immy
Thank you JéJé
The problem is solved

i used several data sources to the same database.
my new shared dimension used distinct data source that the cube.
Now i use same data source in cube and shared dimension
Renzo

"Imtiaz Ullah" wrote:

Quote:
Try to refresh your data source or database and exit and re-open Analysis
Services Console.
Immy

"Jéjé" <willgart (AT) AAAhotmailBBB (DOT) com> wrote in message
news:e4JC$dUnFHA.3300 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
does your shared dimension is on the same database as your fact table?


"Renzo Pamo" <RenzoPamo (AT) discussions (DOT) microsoft.com> wrote in message
news:848212CC-F569-46C0-8E2A-D7857784AA61 (AT) microsoft (DOT) com...
Hello.
I have a problem with views.

I create a view of a table dimension.
I create a share dimension from this view.
but
if i edit a cube and want add this share dimension,
i dont can do , because dont show me in existing dimesions

thanks you





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.