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

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

Incremental processing -> aggregations dropped, even with rigid attribute relations

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
Hi! Very briefly, my goal is to incrementally process the fact data for my SSAS 2005 cube, without losing aggregations. For that purpose, I have defined all attribute relationships as rigid (I don't really expect any of the relations to change) because I hear that flexible aggregations get dumped during incremental processing. BIDS Helper indeed confirms that all of my aggregations are rigid. Then I proces the cube, either via the SSMS GUI using the "Process Incremental" option, or with an XMLA command using type "ProcessAdd". The outcome is the same, no matter which method I use. Then I check the status of my aggregations. I do so first by sending a DISCOVER_PARTITION_STAT Discover XMLA query (http://geekswithblogs.net/darrengosbell/archive/2008/12/02/ssas-are-my-aggregations-processed.aspx), and, as a double check, by sending a query to the cube from which I know it normally uses an aggregation and checking in the profiler whether the aggregation is really used. The result is always the same: The aggregations are lost! The DISCOVER_PARTITION_STAT query informs me that all aggregations have size = 0. Note, that after a ProcessFull, all aggregations are there (with size > 0) and work as expected, so the problem only occurs after incremental processing. Also for the problem to occur it is enough to incrementally process the cube, the dimensions are lef

View Complete Post

More Related Resource Links

Process update - Rigid attribute relations


I have cube with few dimensions having RIGID relationships. I am planning to do a ProcessUpdate on those Dims.
First i did a ProcessFull successfully.
next, Some data, including those rigid attribute related, updated.
When i run ProcessUpdate on those Dims it is failing with below error

'Rigid relationships between attributes cannot be changed during incremental processing of a dimension'

So, what should be my approach now to do a process update?

Thanks in advance

Flexible Aggregations not getting Dropped After Process update



I have read about flexible aggregations that it will be dropped when process update is being done on dimension.

so thought of tyring it out on adventure works table Production.Product . I updated product category table of 1 value i.e. bikes and ran process update on dimension product.

And through darren gosbell's article


i am checking the aggregations from DMV. But still the aggregation is not dropped.

i am using analysis services 2008 version 10.0.1600.22

Please let me know what i am doing wrong over here.



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

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.

dimension's incremental process generates processing on all partitions in cube


Hey eb

Have any one noticed this behavior??

Incremental process (process update) of dimension generates reprocessing of indexes on all cube's partitions,even when no change has occured in that dimension.

I am using SSAS 2005 sp2.

This is disturbing because my cube holds some 700 daily partitions so processing indexes on all of them - on an hourly basis - is very time consuming.

Also it flashes that cube's cache!


I did noticed that changing heirarchies memberskeysunique property to True + changing the toppest attribute in this heirarchy mambernamesunique to true solves this problem.

Is this a must then to prevent recalculating indexes on partitions every process update of dimension??



Incremental processing - do I need to provide specific query?



I have read a few thread on this subject but I didn't get a clear understanding on how incremental processing works.

My question is.. I have a Fact view with with TimeID,Computerid as primary keys. I would expect when I do an incremental processing that SSAS figure out for which keys the cube doesn't have data and insert the missing ones. However, it looks like you have to specify the query to determine the data that should be incremented in the cube, is that right?

How could I do then if my TimeID isn't populated sequentially? For instance, I could write a query to get only today's data but it's very possible that tomorrow or the day after there are still some late rows being inserted with todays timeID but at that time my query would miss these rows. Please let me know if the explanation is a bit confuse.


How to create a Measure without aggregations

Hi all, The data in the fact table has columns which are precalculated ranks for the products based on sales. How to create them as measures in the cube without any aggregations. I selected the properties for measure as "No Aggregations" while creating. But I dont see any data. Then I tried to create those columns as seperate dimensions by doing self join to the fact table.In this way I get the correct data,but the performance is slow. Is there any other way to try out which has both data and performance. Please help me out. Thanks, Sam

how to ensure aggregations and partitions are effectively being used by MDX queries?


we have added partitions and aggregations on all big measures groups, but want to ensure whether they are really being used by MDX query engine or not. I know we can use profiler for this, but want to know how to interpret those details.


Creating aggregations in SSAS 2005



I'm beginning to use the SSAS aggregations. I have created the aggregations for a cube after I have specified the estimated count and I have saved them without deploy them. Is it possible to see the aggregations without the deploy?

Any helps to me, please? Thanks

Categories the Aggregations


I have a cube with one of the dimension as Category(IN, OUT), the measures are sum, avg and distinct products of that category.

The question is: How I can fix / make default and lock the category dimension whenever the cube is browsed by any tool.

The problem is that:

If user exclude the category dimension in the browser window the summation will be of both the categories (IN & OUT), but I always want the output to be divided as category. In other words how can I lock the category dimension as the default selection and always display the mesures in category as below: 

IN Summation Value, Avg Value, Distinct Value

Out Summation Value, Avg Value, Distinct Value

SSAS - Aggregation wizard not finding anly suitable aggregations


Hi all

I am currently working on a financial reporting project. We created a cube that contains general ledger data. At the begining of the development phase, I run the aggregation wizard and SSAS was able to create aggregations. Yesterday I retried to run the wizard and to my surprise SSAS was not able to find any suitable aggregation. I searched on the internet to find out if someone experienced the same behavior and found the following link:

We have several defined hiearchies on the [Organization] dimension that can benefit from aggregations.

I looked at the design of the cube and could not find any reason that could explain the behavior of SSAS (not finding any aggreg.)

In the end I took the solution from the point where it was still able to create aggregations and started to redo all the modifications (one after the other) always running the aggregation wizard in-between. I was hoping that at some point aggregations would not work anymore and that I could identify which modification is guilty. 

Strangely I was able to perform all the modifications and the wizard was still able to build aggregations.

I the scripted the corrupt database and the non-corrupt database and compared them (using a text comparison tool). I was not able to find any significant difference.

Did someone exprience similar problems? :-) I kn

Question on Creating Aggregations based on Time data in a Cube



I have a fact table that lists projects and the site visit dates that related to those projects.   For each site visit date there are a number of associated KPIs.

However to make life a little bit more complicated these KPIs are prorated by year so for each site visit there may be several rows in the fact table that relate to each year ie 2005,  2006 etc...

The issue I am having is that I have been given a requirement to view each KPI at the site visit level.   My first idea was to create an aggregate table for each site visit with totals for each year ie  2005 sales total,  2006 sales total etc...    The issue is that totals can be for any year between 2005 and 2014 and clearly creating all these hard coded totals means there will be a huge number of KPIs required with in-built time logic at the site visit level ie for each KPI I would need a separate measure for each possible year.

Any other alternatives?   The underlying fact table will of course show the end user a list of site visits and the KPIs relating to each year,  but the end user wants to be able to view the data in a repivoted format so that site visit returns 1 row with the prorated date columns appearing vertically across.   For the time being I cannot see that this is possible without having a huge agg

Aggregations based on Dimensions dragged for Calculated measure from different fact table Using MDX



 I am a newbie to Mdx, i am working on education domain. I have a requirement to calculate student counts based on different fact views.

Especially for state,district and school levels we created three different fact views based on applying some conditions on original fact table.

Now i am using only one calculated measure named "Student Count" in my cube. My requirement is, when i drag my district dimension student count count based on district dimension should appear in my measure, if drag both districts and schools together then school facts student count should appear in my count, if i didn't drag any of the two dimensions then state level count defaultly aggregated.

For this, i thought write an mdx basing on dimension i am dragging, so i started with scope function for getting a different fact view based on different fact view,

Scope([Districts].[Districts],[Mesures].[Student Count])

this= ([Districts].[Districts],[Mesures].[District Student Count])

end scope;

like wise for school dimension and so on, but i am getting same value for both of the cases.

could any one help me out in getting solution for this. Is there anyother way other than creating new cubes for each level.

Thanks in advance. Any suggestions are appreciated.


Lakshman A N, S

how to impose javascript event processing?


If I have some form control like textbox and I want the event handler to be located in the html instead of at the server side, how to do that? Of course I can copy paste javascript code in the aspx file. But is it possible to do that using some object oriented approach (ie programmatically in the code behind)?


I am not able to read xml file with XDocument if its Descendants has Attribute xmlns="http://abc.co


I am not able to read xml file with XDocument if its Descendants has  Attribute like:-

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
  <row ID="1" xmlns="http://www.opentravela.org/OTA/2003/05">
    <var country_name="Caribbean and Rest of the world" city_name="Kingston" flight_category="Economy Class" via="Atlanta" flight_departure="London Heathrow" airline_logo="Delta" adult_fare="Delta" child_fare="660" infant_fare="561" date1="132" date2="2010-08-15" />


I don't know what to do ?

Looking for some help..

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

Image processing, determine white space and crop



I have created a image upload for our ID card system to allow users to upload new images, edit them and submit for approval.  This is all working well with a combination of asp.net (c#) and jquery to give a seemless editor etc.

We have had a few users who I cannot believe have scanned a photo of themself and then just submitted it with the A4 page of white and little photo.

I am wondering if anyone can help with a suggestion on how I could possibly reduce the load of these coming through (I can't believe they can be this stupid), it stipulates UK passport standards.

Would my only option be to check for a single continues colour that occurs and if it reaches a certain percentage point say 60% then to just send back an error stating they need to crop the image.

Can anyone help with providing sample or that I can use to move this one on.

I am still in disbelief on this one.  the other one is they take a photo of whole body and other in it and cut straight down middle chopping the people out but supplying a photo that no use for an id photo card....but that I can't imagine being solved programatically as I need to determine where their face dimensions are and what percentage of the actual photo is taken up by it and if it below a threshold reject it.

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