Re: dumb question on Dimensions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

optimizing is a step done thourgh the menu in the cube editor.
so if you have not executed this command, the cube is not optimized and the
system will execute an inner join when you process the cube.
any missing members are not loaded and no key error should occurs.

do you use string (varchar) columns between your fact table and your
dimension table?
if yes, maybe the varchar size of the fact table is different from the
dimension table and the string is truncated, so you'll miss some values.

maybe the problem come from another link. the query executed by AS do an
inner join with all the linked tables!

but this doesn't explain the error (if the cube is not optimized)

"Clint" <ccpatriot12@xxxxxxxxx> wrote in message
news:%23u6ZWSmQGHA.2536@xxxxxxxxxxxxxxxxxxxxxxx
Thanks,

I am positive that my fact table is missing the product (it does exist in
the dimension table)

How do I not optimize the cube?

Clint
"Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message
news:ecuTtLmQGHA.5520@xxxxxxxxxxxxxxxxxxxxxxx
ok, its the error I've described,

your fact table contain a product id which is missing in the product
dimension.
this error occurs when you have no referential integrity between the 2
tables and when you optimize the cube.

first solution:
insure that the product dimension contain all your products. (add missing
products in the product table)

second option:
don't optimize the cube, so AS will execute a query with a inner join
clause between the 2 tables, so the cube will be processed with rows with
existing members in the dimension. (this reduce the processing time due
to the extra join)
to undo what the optimize action do, you have to change the key column of
the product dimension to use the key from the dimension table instead-iof
the key from the fact table.

third option:
when you process the cube, chosse the option to ignore all your errors.

"Clint" <ccpatriot12@xxxxxxxxx> wrote in message
news:elMbg4lQGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
The error I get is:

The attribute key cannot be found..
"Clint" <ccpatriot12@xxxxxxxxx> wrote in message
news:%23KEHsdlQGHA.2300@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for your help.

My problem lies at the processing time. The cube will not process as
it cannot find the member in the fact table. If possible I do not want
to modify the table in SQL.

This functioned fine in AS2000 thus it should be possible?

Clint
"Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message
news:u6jkwBlQGHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
when you access your cube, generally the non empty statement is used
to eliminate unused members in a dimension.

but if you want to insure that your dimension contains only used
members you have to use a view instead of a table to fill the
dimension, and in this view you have to filter the dimension table
with used members into you SQL statement.
another option is to remove unused rows from the database.


"Clint" <ccpatriot12@xxxxxxxxx> wrote in message
news:%23uSqb7kQGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

How do I link a dimension table to the fact table when the dimension
table contains more entries?

eg:
Fact Table:
Bicycle
Motorbike
Car

Dimension Table:
Bicycle
Motorbike
Car
Bus
Train

All I want is too see the data for Bicycle, Motorbike and car... And
I dont want to modify my dimension table.

Thanks

Clint













.

Relevant Pages

  • RE: How to count the cells between CURRENTMEMBER and LastNonEmpty?
    ... I tested how the cube would behave if I also provide the "missing data". ... Slicing doesn't change the members of a set at all, ... One solution--given the dimension assumptions I stated ... the time.CURRENTMEMBER of a specified product and its last sale. ...
    (microsoft.public.sqlserver.olap)
  • SQL 2005
    ... Cubes in a virtual cube 255 maximum ... Levels in a dimension 64 maximum ... Members per parent 64,000 maximum ... Calculated members in a parent measure in session context 31,743 ...
    (microsoft.public.sqlserver.olap)
  • Re: design for distinct count
    ... A fact table with only keyforlevel3 will save disk space. ... use disabled level property of the dimension in each cube for less ... if virtual dimensions based on the dimension are used together. ... > count should be for the lowest level members alone. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... both RDBMS SMO and Analysis Services ... testing domain authentication. ... cube editor slowness if connecting to Oracle. ... Gender dimension to "M" and still browse the Sales cube. ...
    (microsoft.public.sqlserver.olap)
  • Re: Help Needed with Dynamic Dimension Security
    ... business application for securing members. ... and the point in the hierarchy where the security ... > of using Dimension Security with a Virtual Cube. ...
    (microsoft.public.sqlserver.olap)