Showing posts with label dimension. Show all posts
Showing posts with label dimension. Show all posts

Friday, March 23, 2012

I can't dissable a dimension level

SQL Server 2005 april CTP
Hi, I have an snowflake dimension with 2 levels which I used in a cube. But I need to link it to the top level.
In AS 2000, the only thing I used to do is to disable the next level from the linked level. Now i'm trying to do this with no success.
How can I do that?
For example:
Dimension: Warehouse
Level 1: Warehouse
Level 2: Rack
I have linked my cube to the level Warehouse and I want to disable level Rack but AS raises this error: Errors in the metadata manager. The attribute for the 'Rack' source attribute, of the 'Rack' source cube level, is disabled.
I need to disable this level because it isn't linked to the cube.
Any ideas?
Thanks in advance.It was my error. I have mystake definning the key of the dimension. I fixed the key. Then in dimension usage you only have to define the correct granularity of the dimension and that's all.

Friday, March 9, 2012

I am new to data warehousing and have a few initial questions

1. Just to clarify a datamart is collection of dimension tables that related
to a particular fact table within the data warehouse? I understand that the
same dimension table can be used more than once e.g. the Time dimension.
2. I would like to use Analysis Services with Reporting Services to create
the cubes etc. However some people are keen to use Cognos Impromptu with
Powerplay to implement the cubes etc. Are there any advantages that this
combination offers over the Cognos alternative other than the cost?I typically think of a datamart as being department specific (such as
Accounting or Payroll) and a data warehouse as being a consolidation of
multiple datamarts across the enterprise.
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:A4C4B887-91B7-4C98-BB72-48F275AE21D3@.microsoft.com...
> 1. Just to clarify a datamart is collection of dimension tables that
related
> to a particular fact table within the data warehouse? I understand that
the
> same dimension table can be used more than once e.g. the Time dimension.
> 2. I would like to use Analysis Services with Reporting Services to create
> the cubes etc. However some people are keen to use Cognos Impromptu with
> Powerplay to implement the cubes etc. Are there any advantages that this
> combination offers over the Cognos alternative other than the cost?

I am new to data warehousing and have a few initial questions

1. Just to clarify a datamart is collection of dimension tables that related
to a particular fact table within the data warehouse? I understand that the
same dimension table can be used more than once e.g. the Time dimension.
2. I would like to use Analysis Services with Reporting Services to create
the cubes etc. However some people are keen to use Cognos Impromptu with
Powerplay to implement the cubes etc. Are there any advantages that this
combination offers over the Cognos alternative other than the cost?
I typically think of a datamart as being department specific (such as
Accounting or Payroll) and a data warehouse as being a consolidation of
multiple datamarts across the enterprise.
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:A4C4B887-91B7-4C98-BB72-48F275AE21D3@.microsoft.com...
> 1. Just to clarify a datamart is collection of dimension tables that
related
> to a particular fact table within the data warehouse? I understand that
the
> same dimension table can be used more than once e.g. the Time dimension.
> 2. I would like to use Analysis Services with Reporting Services to create
> the cubes etc. However some people are keen to use Cognos Impromptu with
> Powerplay to implement the cubes etc. Are there any advantages that this
> combination offers over the Cognos alternative other than the cost?