Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Advanced Properties for Dimesions

 
   Database Forums (Home) -> OLAP RSS
Next:  Confusion: database devices and segments on a SAN  
Author Message
Ram11

External


Since: Sep 03, 2004
Posts: 7



(Msg. 1) Posted: Mon Jul 18, 2005 11:07 am
Post subject: Advanced Properties for Dimesions
Archived from groups: microsoft>public>sqlserver>olap (more info?)

Hi,
I am currently using Analysis services. Once I finish building a cube, I
would like to modify certain properties for a dimension using the advanced
properties tab. Most of the properties are grayed out. would there be a
reason for this.

Env: MS Analysis Services 2000 with SP4.

Thank you
Ramdas

 >> Stay informed about: Advanced Properties for Dimesions 
Back to top
Login to vote
Lutz.Morrien

External


Since: Jul 19, 2005
Posts: 1



(Msg. 2) Posted: Tue Jul 19, 2005 1:00 am
Post subject: Re: Advanced Properties for Dimesions [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Ram,

if you are using shared dimensions in a cube, these dimensions cannot
be altered in the cube designer because they could be used in other
cubes at the same time. Changing the dimension would have an effect on
all cubes which use this dimension. However, you can change shared
dimensions in the dimension designer (getting a warning indicating
which cubes will be affected when you save the changes).

HTH Lutz Morrien

Ram wrote:
> Hi,
> I am currently using Analysis services. Once I finish building a cube, I
> would like to modify certain properties for a dimension using the advanced
> properties tab. Most of the properties are grayed out. would there be a
> reason for this.
>
> Env: MS Analysis Services 2000 with SP4.
>
> Thank you
> Ramdas

 >> Stay informed about: Advanced Properties for Dimesions 
Back to top
Login to vote
Dave Wickert MSFT

External


Since: Sep 09, 2003
Posts: 254



(Msg. 3) Posted: Wed Jul 20, 2005 7:57 am
Post subject: Re: Advanced Properties for Dimesions [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Typically the "graying" out of some properties means that it cannot be
edited in that environment. For example, the aggregation usage property is
not set in the dimension editor, but rather only when you add the dimension
to a cube and then look at the dimension in the cube editor -- i..e. it is a
property of the dimension when it exists within a cube -- not as an
independent, standalone dimension by-itself.
--
Dave Wickert [MSFT]
dwickert RemoveThis @online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Lutz.Morrien" wrote in message

> Hi Ram,
>
> if you are using shared dimensions in a cube, these dimensions cannot
> be altered in the cube designer because they could be used in other
> cubes at the same time. Changing the dimension would have an effect on
> all cubes which use this dimension. However, you can change shared
> dimensions in the dimension designer (getting a warning indicating
> which cubes will be affected when you save the changes).
>
> HTH Lutz Morrien
>
> Ram wrote:
>> Hi,
>> I am currently using Analysis services. Once I finish building a cube, I
>> would like to modify certain properties for a dimension using the
>> advanced
>> properties tab. Most of the properties are grayed out. would there be a
>> reason for this.
>>
>> Env: MS Analysis Services 2000 with SP4.
>>
>> Thank you
>> Ramdas
>
 >> Stay informed about: Advanced Properties for Dimesions 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Advanced properties in cubes - Hello, I am trying to use an advanced properties with a cube called "source data filter". I am trying to short the fact table using this stuff, so I wanna filter by an element of my entity dimension. I write in this record something as this: ....

Member Properties - Hello, Is it possible to use Member Properties in a calculated member? For instance in my time dimension I have a level called Month. Each month has a hard coded number assigned to it... What I want to do is create a calc member that reads this hard....

Measure Properties - WHY i can ask for some properties and.. - My Question: i can ask for some measure properties like ID and NAME, exaample: [Measures].[StandardPrice].Properties("ID") but i cant ask for the properties "Description" or "Data Type". Is there any way to do that?? We ne...

Attribute Relationship Properties - RelationshipType - Below is a part of the description about RelationshipType from AS 2005 BOL. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uas9/html/fce511af-66d7-42fc-bb3a-6c516f16b10e.htm ....If you define a relationship as flexible, aggregations are not dropped and..

MDX - PROPERTIES MEMBER_KEY - I'm running the below query (SSAS2005), attempting to return the member key rather than the member name: SELECT [Measures].[Billing Revenue] ON COLUMNS , [Date].[Week Begin Date].members DIMENSION PROPERTIES MEMBER_KEY ON ROWS FROM [Sales] For the...
   Database Forums (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]