.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

I need a grouping and cumulative sum of data(TFS SSAS Report)

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
It is a MDX query (TFS Warehouse)     WITH MEMBER [Measures].[Date Value] AS     [Date].[Date].CurrentMember.Member_Value     MEMBER [Measures].[CalculatedRoughOrderOfMagnitude] AS Iif(     [Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].CURRENTMEMBER IS [Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].[All].UNKNOWNMEMBER,     2,     2^([Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].CURRENTMEMBER.MEMBER_VALUE+1)     )   MEMBER [Measures].[ActiveRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Active + "]") , [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )   MEMBER [Measures].[ResolvedRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Resolved + "]"), [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )   MEMBER [Measures].[ClosedRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Closed + "]"), [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )           SELECT {  &nbs

View Complete Post

More Related Resource Links

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Display multivalue data in crystal report


i Want to show data for single employee like this like this

Emp Id : xyz

Emp Name : abc


Child name      Date of birth     education

abc                     12/12/2000    o levels

The report cannot be opened because the data source associated with it is not a report model.


i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?


grouping summary data gridview


how can I gruping summary data in gridview like that; Thanks for helping


Car                   Rate 1               Rate 2            Rate 3  

 BMV                 5                          7                       9

                         4                          6                      7


Microsoft Report Viewer control to display data on one page


Hello everyone,

I am wondering if the Microsoft Report Viewer control allows for display changes.  Say for instance a user wants would like to see all the data requested then another time would like to toggle thru the pages of infomation.  So does anyone know if the control allows for display changes from complete view to paginated viewing.  I am using MS VS 2008 with ASP.NET 3.0.  Thanks for your response.


VS2008 BIDS Report export to Excel not grouping the same as VS2005

I have a report that I created in VS2005 BIDS and got it to export to Excel to group/subtotal the same way it does in the BIDS report window.  Now I have copied the .rdl files to a VS2008 project, open it in VS2008 BIDS, made NO changes to the report format and the exported Excel file is combining what should be the 2nd and 3rd groups into 1 group.  In the BIDS window, the grouping is working correctly.  Does anyone have any ideas what has changed between 2005 & 2008 that may cause this problem?  Thanks in advance.    

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

Displaying a Parameter Value in the report footer that corresponds with the parameterized data on ea

I've got a report that has only one parameter, it determines the department (or departments) to base the report on, the parameter is set to allow for multiple values. The report returns only on page per department, so the report could be anywhere from one to a hundred pages, one page per department. I've included a text box in the report footer that displays the report name and the parameter value, the expression looks like this: =Globals!ReportName & " For Department " & Parameters!Dept.Value(0)    I know that in this example the zero inside of the parenthesis of the parameter value is what is returning the actual value when the report is rendered, and I understand that the zero is value in the array of parameter values. What I'm looking to do is adapt this expression so that the parameter value rendered on each page corresponds with the data (departement) displayed on the specific page. So using the example of the data, if the user selected three departments in the parameter drop down, then each page that displayed the different department’s information would also display that departments name in the page footer text box. I'm thinking that each time a page is rendered that there is a group or global variable that can be called to provide this dynamically but I can't seem to find the information. Appreciate any help, Dan

Getting filtered data from Role based SSAS security

Hi everyone,I've got a heap of reports that are based on various SSAS cubes. I have roles defined on these cubes that restrict data via certain dimensions. Question is, will these restrictions filter through to the report...ie, if I have a sales person restricted in the SSAS cube to only see sales against their territory (restricted in the Territory dimension), when they run the report will it filter the result based on their SSAS credentials and only show the data they have access to (even though the SSRS report has no direct filters or parameters applied)?Cheers for any help!!

Report Builder Report manage data sources - relink programmatically

As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)

Different number of data in Report after using Render method.

Hello All, I have CRM4 report that i execute from outside the CRM system, using the ReportExecutionService2005.asmx web service, i get the report exported directly by calling the Render method of the webservice, but when i compare the data of the Report outside the CRM is less then the data in the report executed from within CRM system. I have tested the same report with same user in CRM and outside CRM but data is different. can someone guide me what is going wrong in the Render method.BharatKumar Bambhaniya Software Developer.

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

Report with two data sources

Hello, I have two data sources: an Oracle table and a SSAS cube. I need to make a report with some information from the table and some from the cube. Example:   Oracle table ID, Comment SSAS ID, Value, Description Report ID (the join key); Value; Description; Comment.   Is it possible to do that? Many thanks  

Browse SSAS Cube Data From Your iPhone

Does the world want an iPhone app that allows you to connect, browse and pivot SSAS cube data?  What features would that app have?  Is there existing apps that are close?  Looking for others thoughts on this concept.  Thanks in advance!

Collapsed Grouping in Data View

I have created a data view that groups data to roll-up common items. The problem is that even though I have the data view group properties set to collapse by default, when the user opens the page, the contents are not collapsed by default.

What are my options when I need to create a report with data from multiple sources?

Hello all,  What are my options when I want to create a report that will get records from multiple data sources based on data from a parameter? The user will enter the customer ID, I have to check that ID against 5 different data sources. Have you guys done anything similar? Should I leverage SSIS on this request, adding an extra layer of complexity? Should I do this all from SSRS? What are my options?
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