.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

key not found for the attribute in dimension

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :Sql Server

Hi experts,

i have this problem: I have a fact table for sales analysis and i have a dimension for article of sale. The problem is that in the fact table i can find multiple records that not is present in  the table of articles. This condition not is an error because the software for the sales permit to do a sale without an article codified.

How can i solve this problem?

Can i force this error? If i set custom error on dimension with ignore key error enabled, the cube process however go in error

View Complete Post

More Related Resource Links

Getting counts by 2nd Date Dimension Attribute with Snapshot Style Fact Table

  I have an MDX question finding hard to solve.  I have a Snapshot Fact Table with a snapshot of the records in the source system for each batch date.  All records in the fact table are assigned the batch date with the batch date key.  There are many records for each day and each batch date is an entire copy of the source records.  So, the grain of the fact table is one record for each batch date that exists in the source system.  These facts rows have another date in them for when the record was entered.  This date is different from the batch date in that the batch date is based on the day the batch was processed and the entered date is based on when the record was entered.  If a record was entered many days before, its batch date will be today but its entered date will be several days ago.  Therefore each day a copy of all the records entered the previous batch date and all the records added on today's batch date are present. Fact Table : FactSnaphshotKey (surrogate for easier administration) BatchDateKey (link to batch date dimension – date dimension, first in dimension list so it is used for semi aggregate measures) EnteredDateKey (link to entered date dimension – date dimension) Facts Count – measure for fact table - default measure from Analysis Services cube 2 Dim

Different attribute name in each dimension for a role playing dimension

Is it possible to name the attribute differently in a role playing dimension. For example I use the Date dimension as the role playing dimension for Ship Date and Order Date. When I use these attributes on the report, both of them show as 'Date' which is the name of the attribute in the Date dimension. Is there any work around to implement these names differently?

Dimension design: Key column of non-key Dimension Attribute

Assume I have a product dimension where key dimension attribute is product code - this is a very large dimension with more than 1 million members, the key column for this attribute is productID (integer). There will be other attributes in this dimension related to key attribute.   My question is about the key columns to be defined for these other attributes. As it is related to key attribute, it has to include ProductID as part of key and hence forming a composite key - e.g. Product inception date - the key column for this has to be ProductID + date as many products can have same date. This design will violate the best practice recommendation from MS to have only numeric key columns for very large dimension attributes. But I can't find a way around this and assume this will be case for all non-key attributes in very large dimension. Is my understanding right? I assume this will be an issue for everyone? Any standard way to get around this? Or best to leave it as such? Thanks in advance.

A duplicate attribute key has been found when processing

Hi When I process one of my dimensions it fails and I get the following error: Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'Customers', Column: 'DisplayName', Value: 'Stephen Grant'. The attribute is 'Display Name'. I don't know if this is significant, but the attribute to which it is making reference was added through BIDS 2008 (the cube was originally created with BIDS 2005).  There are no duplicates of 'Stephen Grant' in the DisplayName column. Not that it should matter if there were as this attribute has a cardinality of Many, with an rigid attribute relationship directly to the dimension's key attribute. The Key column for the Display Name attribute simply refers back to the same (DisplayName) column in the table. If I delete this record, or even just update the DisplayName field from 'Stephen Grant' to something else, the dimension processes just fine. I can't work out what it is about this record that is stopping the dimension from being able to process. Can anyone help me figure out what's going on? Julia. P.S. I am using SSAS 2008 on Windows Server 2008

Key Dimension attribute not visible in cube browser

When browsing the cube either through managemnet studio the key dimension attribute is not visible . However when I browse just the dimension, I'm able to see this attribute. Is this the default behaviour ?. Is there any property I need to set to make it visble ?. The AttributeHierarchyVisible property is already set to true.

cube deployment fails- A duplicate attribute key has been found when processing

I am trying to create a cube using the same process that I always do. however this time I get an error message "Warning 4 Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_ALL_ResultsNewest', Column: 'MktCapGroup', Value: ''. The attribute is 'Mkt Cap Group'.  0 0 
This is using alot of data but I have created similar size cubes before. I create simple cubes with a single dimension and all the attributes related to a single master attribute. I am a data analyst, not a technologist and don;t have any real understanding of cube internals beyond the basics.

Errors in the OLAP storage engine: The attribute key cannot be found: Table: table_name, Column: col


I get this error on occasion while processing (full) the OLAP database, and I know that the value 822518 is part of my dimension table refered by the fact table.  I usually just re-process (full) the OLAP database and don't get the error anymore.  Is this a problem with the order in which the objects are processed?  If so, how can I change that?



Dimension key attribute changes in fact table



How do I need to handle a case in which the fields in a fact table that represent the foreign keys to the dimension tables might change? What kind of process do I have to do to the cube?



Get SSAS Dimension Attribute SQL Column Name using C#



I am trying to determine what the real SQL Server Column name is for a Dimension Attribute using ADOMD.net, however all I am able to find is the the TABLE_NAME and COLUMN_NAME Columns using the GetSchemaDataSet("DBSCHEMA_COLUMNS", null) function.

Does anyone have any suggestions?



Dimension Attribute Reserve Word in AMO



I am using SQL 2008 R2 Standard SSAS. Has anyone tried creating a dimension attribute with the name "Name" using AMO.

AMODimensionAttribute = AMODimension.Attributes.Add("Name") - This does'nt work.

I get an error that, “dim_xxx” dimension contains a member property with invalid name “Name”. “Name is one of the Reserved Words”.    We can always make sure to check if the attribute name in the OLTP DB is "Name" and then prefix it with some additional characters.  But it restricts that, I can’t create an dimension attribute with the name “Name” using AMO.





Personalization Extensions and Attribute / Dimension visibility


Does anyone know if it is possible to hide / show Dimensions, Measure groups, or Attributes via MDX?  I am using personalization extensions (which is awesome) to create "things" on the fly keeping them separate for each client who uses our cubes.  But now we are entering the realm of "we don't want to see that, as it doesn't apply to us" [they came into the picture after so much was already built].  It would be great if I could use some MDX to hide entire things at a pop, and it is already built in.

Does anyone know if this is possible?  Or would I have to use XMLA to accomplish this?  Or would it be better to use the .Net classes (as they provide a safety layer between my code and future changes)?

Thank you in advance,

After adding a new attribute to a dimension and saving, SSAS unprocessed partitions. Can anyone help



After adding a new attribute to a dimension and saving, SSAS unprocessed partitions. Can anyone help me understand why this happened and point to some reading materials for detail? (can't find any...)


SSAS 2008 - Dimension colmun/attribute not visible in cube browser?


Hi, I have one dimension and one fact table in SQL 2008 server...

i.e. DimEmployee (Columns : EmployeeID, FirstName, LastName, DateOfBirth, Addrss, PostCode, MobileNumber, Gender)
     FactEmployeePay ( Columns : EmployeeID, Amount)

When I create SSAS 2008 cube on those two tables (Relationship is EmployeID colmun) , deploy/process project/cube and then I go to "Cube Browser", but in dimension Employee table I can not see any columns other than EmployeeID. Why in this simple cube I can not view other dimension columns like FirstName, LastName,....

Any idea for SSAS 2008?


Need to access MemberValue of a dimension attribute regardless of level.


I have a Product dimension that has an attribute (Std Cycle Time) that is numeric. I need to use that value in a cube calculation.

How can I access the value regardless of how the data is cut?

I tried this method:

  [Dim Product].[Product - Std Cycle Time].CurrentMember.MemberValue
FORMAT_STRING = "#,0.000", 
VISIBLE = 1 ; 

But what I see in a Pivot Table when I pull this value in is 'ALL' unless I pull the Std Cycle Time attribute into the table.

I understand that behavior. If specific attribute is not pulled into the pivot table, SSAS defaults to the ALL member.

Question is I want to retrieve that Std Cycle Time to use it in another calculated member to compute a weighted average. Basically, I want to do this:

 //Compute the Weighted Average of the Std Cycle Time based on the runtime for the given product.

Errors in the OLAP storage engine.The attribute key cannot be found.


Hi Experts:

Please help me with this problem, thanks!

Following is details:

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_IRS_DIM_CUSTOMER', Column: 'CUSTOMER_NAME', Value: '????????? ????????????'. The attribute is 'CUSTOMER NAME'. Errors in the OLAP storage engine: An error occurred while the 'IRS DIM CUSTOMER' attribute of the 'IRS DIM CUSTOMER' dimension from the 'IRS_CUBE' database was being processed.

Essentially the workflow is , Spool data from Oracle db to flat text format -> Import data into SQL server from flat text -> Build cube -> Do some analysis.

We have two servers in different location. The server in Euro works perfectly but the other always encounters the previous error. Both servers' Language for non-Unicode programs are set to 'English(US)' by the way. Howerver, the server in Euro use '???????' to represent Chinese or Japanese words while the other server use some sort of mess codes(a black diamond with a white question mark inside).

I wonder if it is because the mess code causes this problem, but actually I still cannot understand why there's a different while spooling data.

Any help will be greatly appreciated! Many, many thanks!


Format dimension attribute with leading zero


I have a attribute in a dimension that represents a hour. The value is an integer. How do I format this with leading zeros, as Excel will treat is as string while sorting (meaning 0,1,10,11,12,2,3,...). I tried the formating attribute in the key column in the dimension-attribute. But that has no effect.



Handling 404 page not found with Error page



      How do i handle 404 page not found?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend