.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

Measure Group Shows Empty

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

I've searched this forum and read a few posts similar to mine, but they either weren't answered, or the answers didn't work.


I have an Analysis Services database with about 8 measure groups and about 25 dimensions.   We just released our new version into our production environment today, and we have one measure group that shows up completely empty.  All functionality worked in development, was tested in stage, but now this one measure group doesn't work.  I can check all connections to db, data source, dsv, to cube, to measure group, and everything is fine.  From within BIDS, I can right click a fact table and explore data, and data is there.  Data is also there in the fact table inside the database engine.  When I try and browse the cube, or query with MDX, just the one measure group shows all null.  Any thoughts?

View Complete Post

More Related Resource Links

processing measure group : memory error : the operation cannot be completed because the memory quota

Hi, I'm stucked with this problem. Untill last week, the cube processed without any problem. Since last week, I'm getting this error. I have been searching in different forums, and I tried some suggestions, like changing memory limit properties, ... It is getting worse.. So I reset all properties to default again. I am running SQL-Server + MS-AS 2005 SP2 on server with 4GB of memory. This is a dedicated server, nothing else is running on it. The fact table has +/- 14 million records, several dimensions en 2 measure groups. I don't have problems to process the dimensions, but when I try to process the cube or the measure groups of that cube separately , the error persists. I have changed the datasource view, and replaced the fact table by a Named query. Even when I put a 'WHERE datapart( year , fact_date ) >= 2009 ' clause to reduce the number of records to +/- 5 million, I'm still getting the error. I don't understand what is wrong, the cube always processed since +/- 2 years. As I said, I have found a lot of this kind of Issues on different websites, I have been trying to change some properties. But this still does not solve the problem. Could it be that MS-AS settings are corrupt somewhere ? Is it a good idea to re-install MS-AS 2005 + SP1 + SP2 ? Or is there another reason possible ? I really appreciate any kind of help, because I'm

Empty/blank group at top of matrix table

I'm having trouble creating a report with matrix tables.  I've got all the data showing up properly, but the first line in the preview is always blank.  If I subtotal the groupings, I get a blank Total line as well.  How can I stop this from happening? I'm using SQL 2005, report designer.  Data is coming from a stored procedure.  I've executed the sp in management studio as well as in the data tab of the report and it comes back with the correct data (no completely blank/null lines).  I'm new to SSRS and I've tried googling for a solution, but haven't found anything similar.  Below is the sp and the output data. SP: SELECT s.Status_Name + ' (' + CAST(CAST(s.Status_Weight*100 AS int) AS varchar(50)) + '%)' AS Status, s.Status_Order, CASE WHEN co.Company_Name IS NULL THEN '' ELSE co.Company_Name END AS Company_Name, co.Est_Income FROM tblStatus AS s LEFT OUTER JOIN tblCompany AS co ON (co.Status_ID = s.Status_ID AND co.New_Upsell = @NewUpsell) GROUP BY co.Company_Name, s.Status_Order, s.Status_Name, s.Status_Weight, co.Est_Income ORDER BY s.Status_Order, co.Company_Name Output (mgmt studio): Still Connecting (0%),1,Company1,400000.00 Still Connecting (0%),1,Company2,3000000.00 Clear Future (0%),2,Company3,250000.00 Clear Future (0%),2,Company4,250000.00 Appointment (10%),3,,NULL Proposal (40%),5,,NUL

how to process just one partition along with other measure group and dimension in SSIS package Analy

HI All, i have to process just one partition1  of measure group A ,along with this i suppose to process all the Measure group and dimension with the help of SSIS Package Analysis Services Processing task. Partition1 having a query which fetch data only for previous day only. what i have done i select partition 1 in process data mode,all other measure group in full mode and dimension in process update mode.   i haven't taken measure group of partition1 and also not taken cube in the processing list ,when i run the package ,it runs suceesfully but data not get uplaoded into the Cube.   kindly suggest what other measures should i take to update the data . Amit

SSAS 2008 Measure group Distinct count

Hi all, I have a data of as number of trasactions,DD, SO, BouncedDD, CancelledDD all are in count (number) while adding these measures manullay to a measure group I have selected usage as DistinctCount for one measure and for all the remaining measures as DiscinctCount.While deploying the cube it shows error as "Fact table canot have more than one distinct count"  

Measure Group Bindings

Hi fellows, how are you doing? I'm having a problem trying to associate a Measure Group that haves 2 columns for two different attributes of a dimension with a regular relationship. I've just associated one of the columns in the relationship window, and then in the Advanced window associated the another. While from the configuration point it's fine, when I try to break the values of this dimension group down by the two different attributes, just the one that was associated in the main window works, when I try to break the analysis by the second attribute, it repeat the total of the measure by each attribute. Why this is not working? Thanks, RafaelRafael Veronezi Database Administrator | BI Analyst Twitter: ravero Blog: http://raver0.wordpress.com

Search Scopes - new display group always shows "This site:"


Hello all,

I have created a new scope (Scope A) and everythind works ok. Then I wanted to create a search page (my search page with a search box and search core results) to show only the results from the created scope.

I created a new search display group (Display Group B) and assigned the "Scope A", configured the search box to display the "Display Group B" hidding the scopes drop down list and it didnt work as I wanted as it displayed all the results by default.~

How can I remove the "This site" from my display group, keeping only one scope as the default one?

Thanks for all the help

Best Regards,

André Cunha




Financial Reporting Measure Group question in Adventure Works 2008 R2


I need some help understanding the Financial Reporting measure group in Adventure Works 2008 R2. I get a value of $12,609.503 when I just drag amount into the query pane. Which accounts is this made up of, and how does it get to this result? Thanks.

Alter measure group: Impact on cube processing?

Hi All,

I have a XMLA script to alter source column (<ColumnID>) of a measure. I would like to know
following regarding the script:

1 - Do I have to 'Process Full' the cube or other processing options are applicable?
2 - The cube takes 2 hrs to process. Will there be reduction in process time processing the cube
    after running the script or will it take the whole 2 hrs?
It running cube on production so I would like to minimize the impact of the alter script.

Thanks in advance for any help.

Hide a measure group in excel 2007 'Show Fields Related to'


Hi All,

I know that if a I want to hide a measure group to users I have to set the properties 'Visible' to false for all the measure of the measure group.

But when I open a connection to the cube with Excel 2007 I see again the measure group in the drop down list 'Show Fields Related to' in the 'Pivot Table Fields List'.

I don't see it in the measure group list when I choose 'All' in the 'Show Fields Related to', but i don't want to see it in the list 'Show Fields Related to' too.


How I can do to hide permanently the measure group?


Thank you all,


SSAS Claculated Measure ignore empty rows issue



I have a calculated measure [Revenue Varaiance] which is basically a variance of current year and lastyear Revenue.

Last year Reveue Measure name is [Pyr Revenue Actual] and for current year  is [Revenue Actual ]

Equation for my Revenue Varaiance is given below.

IIF([Measures].[Pyr Revenue Actual]=0,IIF([Measures].[Revenue Actual]=0,0,1),([Revenue Actual]-[Pyr Revenue Actual])/[Pyr Revenue Actual])

Out put:

Quering LastChild-measures results in scanning all partitions in measure group



I have a large fact table with daily warehouse snapshots. I created a measure group with 2 measures with LastChild aggregation function (balance in pieces and EUR). I built monthly partitions in the measure group. When I run queries like this:

select {[LastChildMeasure1]} on 0,
non empty [Locations].[Location].[Location] on 1
from [Cube]

, SSAS 2008 scans only last partition. But when query both measures:

select {[LastChildMeasure1],[LastChildMeasure2]} on 0,
non empty [Locations].[Location].[Location] on 1
from [Cube]

, SSAS begins to read all partitions. When I remove "non empty" before [Locations].[Location].[Location], then SSAS reads only last partition again, but null-rows appear in query results. My Time dimension has "Type=time" and all internal DATAID's are in right order and all attribute relationships are correct.

Is there any suppositions why SSAS reads all partitions and how to avoid this?

DistinctCount and incorrect measure group


SSAS 2008.  I have one measure group with regular sum and count aggregations.  I have another measure group for a DistinctCount aggregation from the same source table.  I would like to add a second DistinctCount aggregation.  However, when I add this measure through Visual Studio, it puts it under my sum/count measure group.  Any ideas on how to force it into my DistinctCount measure group or a brand-new measure group?



Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio


I need some help.


If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.


My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.


Is this a bug or am I missing a setting?

Link 1 measure group to 2 different role playing date dimensions and browse it by same date dimensio


hello, I'm Using SQL Server Standard 2008.

I have a measure group Sick leave, which holds measures like sick duration, and number of sick registrations.

For sick duration, the measure group is linked to the Date End role playing dimension by Sick End Date.

For Number of Sick registrations, the measure group is linked to the Date Start role playing dimension by Sick Start date.

But now I want to browse both sick duration and number of sick registrations at the same time against Date dimension,

How to do that?


MDX, count of rows with non empty measure



I have a fact table with 8 measures that aren't always all available. I'd like to aggregate them with AVG() so I tried to create a calculated member:
where I1 is the measure (aggregated by sum) and #Indexes is a count of rows automatically created by SSAS. But obviously the #Indexes includes all rows, also the ones with empty measures.

M1   M2 ...
null   5
10    6

I have to have 10 as AVG rollup of M1 in this small table and now I'm getting 5.

how could I solve this?

influence processing order of partitions of measure group



  • a Measoure Group which needs full processing
  • SQL Server 2008 R2
  • the question is regarding performance

The measure group is partitioned by qarter - therefor I have some 30 partitions at the moment. I issue a processFull of the MEasureGroup and let Aanaysis Services Descide the parallelism. In Common it ends up to process between 8 and 12 partitions in parallel (on the 12 Core Machine).

The point is - my partitions growth over time - so older partitions are smaller then newer partitions. Usually Analysis Services ends up starting the newest partition at last - which is the biggest one - and therefore ends up phasing out the processing on a sinle processs (not utilising) the server efficient - because the newest partitions is somehow the biggest and needs the most time - but had nothing to process anymore.

Is there a way to

  • let the server deside the degree of parallelism (like now)
  • but specify the order (lets say start with the newest partitions and end with the oldest)

I have not found anything in the documentation

  • mabe something about processingpriority
  • or just the oder of the process statements in the parallel processing batch - if I would specify them




2008 R2 Web Service URL - just shows empty page and SQL version number


In SQL Server 2008 R2 I installed reporting services.


When I go into the Reporting Services Configuration Manger and then Web Service URL and click the hyperlink it just goes to an empty looking page.


localhost/ReportServer - /


Microsoft SQL Server Reporting Services Version 10.50.1600.1 

The Report Manager URL works fine.

I have uninstalled and re-install Reporting Services two times now and changed the URL address several times too.  Still it's always stuck on this page.

Any ideas?


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