Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

sql

Error: Attribute key cannot be found

Helo, I have the following problem

I have one fact-table in my cube
And I have one dimension table

When I process the cube I get the following error:

"Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306."

I understand the error, and I know why I get the error, but how can I solve the error

In the fact-table there is a record with key 306, but this key is not found in the dimension table. What I want is that in the cube are all the record that are in the fact-table with a reference in the dimension table, so the record with key 306 must not be in the cube

Anyone an idea ?

Thx

Look at your processing options. On the "Dimension key errors" tab select "Use custom error configuration" and change the setting to "Convert to unknown".

|||

I have this same situation. But where are the processing options found? I don't see it!

thx,

Marilyn

|||found it! thanks.|||

Is there a way to set the "Dimension key errors" to automatically use the 'Use Custom error configuration' without having to set it each time processing is performed?

thx,

-Marilyn

|||

It is also possible to set ErrorConfiguration on the partitoin, measure group or on the cube.

Take a look at the properties dialog for cube or partition in SQL Management Studio, you will find a Error Configuraiton tab there.

In BI Dev Studio look at the properties panel and find ErrorConfiguration property. Once you set it to "Custom", you will be able to set individual error configuration properties.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

right-click on the cube in the solution explorer pane.

select 'process...'

press the 'change settings' button.

select the 'dimension key errors' tab

select the radio button 'use custom error configuration'

|||

Your settings won't "stick" in the Analysis designer itself for some reason... you must create an Analysis Services Task in BI Studio to run against the cube you've created.

|||

Hello,

I get the same error msg but here's the situation

I create a new project, with a data source and a data source view with only one table

I create a dimension base on this table and try to process it

There's no cube, only a dimension and it failed with attribute key not found error

After many test I discover that the lines causing the error where random and the error line are same as those that work

I understand the reason why this error is thrown when a cube reference to an item that doesn't in the dimension but in my situation I really can't understand what happen !!

Can somebody help me with this one

thank you

Billy

|||make sure you process your dimensions before your CUBE.

error with calculation tab

currently using the SQL Server Business Intelligence tools to develop my project. After the cube creation, i clicked on the Calculation tab and it just automatically quit the whole software. When i open back the software and the project and click on the Calculation tab again, it won't quit the whole software but had this error message "Error with application" and on the left panel "error loading meta data, could not access to the database" something like that......

izit the software corrupted or there's any setting that i should change? the connection to the database is fine as i test run it and it succeeded.

plz help........

Hey there,

Check out this thread, follow the links a couple of posts down and you should be able to solve this problem.

C

Error with attributeKey

Hi everybody,

I have a problem while creating my cube.

In my database i have two tables

Article (ArticleKey, Libelle, ...) articleKey is the pk

FactStock (stockKey, ArticleKey,...) strockKey is the PK and articleKey reference column articleKey in article table. There is integrity constraint between this two columns

In BIDS, when i try to mount my cube with this two lments and others. i have an error : "Erreurs dans le moteur de stockage OLAP : La cl d'attribut est introuvable : Table : dbo_factStocks, Colonne : ArticleKey, Valeur : 47107" . So, I search help on web and I found this page : http://support.microsoft.com/kb/922673/en-us .
So i try element that was written on it. but it doesn't seems to work. If I check existence of an article with the articlekey value of 47107. I found one item. So my question is : Why? If the article exists why i have this error?

Christophe

Hi Christophe,

The page you referenced mentions that: "This behavior may occur when you have not processed the corresponding dimension before you process the cube". Assuming that you have an Article dimension, did you process it and confirm that the article with articlekey value of 47107 appears when you browse the dimension data?

|||

Hi,

Thanks for your reply. You are right. This was the origin of the error. The value wasn't in my dimension when in browse it.

Christophe

Error while processing cube

Hi All,
I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>
I don't understand why as my project deployement completed successfully
and a "Test Connection" of my Data Source returns a "Test connection
succeeded"
My user is 'sa' so I don't think rights are a problem here.
Does someone have any idea on this ?
Thanks in advance
Eric
Hello esl,
This error is more than likely caused by the Analysis Services service
account not having the permissions to connect to your data source. This
happens when you use windows authentication for the data source
connection and the AS2005 service is running under local system
account.
Try to run the Analysis Services with a windows account that has rights
to connect to your data source. The cube should then process.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com
|||Hello Myles,
you're right it was indeed a problem with the impersonation account I
used for the data source.
I know use the service account which I have given required permissions
(domain +db) and it works fine.
Many Thanks for your help !
Eric

Error while processing cube

Hi All,
I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>
I don't understand why as my project deployement completed successfully
and a "Test Connection" of my Data Source returns a "Test connection
succeeded"
My user is 'sa' so I don't think rights are a problem here.
Does someone have any idea on this ?
Thanks in advance
EricHello esl,
This error is more than likely caused by the Analysis Services service
account not having the permissions to connect to your data source. This
happens when you use windows authentication for the data source
connection and the AS2005 service is running under local system
account.
Try to run the Analysis Services with a windows account that has rights
to connect to your data source. The cube should then process.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com|||Hello Myles,
you're right it was indeed a problem with the impersonation account I
used for the data source.
I know use the service account which I have given required permissions
(domain +db) and it works fine.
Many Thanks for your help !
Eric

Error while processing a cube :(

I am getting the following error when trying to process my cube. Can someone
please guide as to how this problem can be solved. Thanks
Data source provider error: [Microsoft][ODBC SQL Server Driver][
SQL Server]Cannot resolve collation conflict for equal to operation.;37000;
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...When you process the cube you can see the query that olap is using to
retrieve data from SQL.
If you have a look at that query he is going to match several fields to each
other. In one of the fields you have a collation problem. You try to match
2 field together with a different collation.
You will have to check the collation settings of these fields.
Regards,
Nico
"Learner" wrote:

> I am getting the following error when trying to process my cube. Can someo
ne please guide as to how this problem can be solved. Thanks
> Data source provider error: [Microsoft][ODBC SQL Server Driver]
1;SQL Server]Cannot resolve collation conflict for equal to operation.;37000
;
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NE
T resources...
>|||Tons of thanks Nico.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?