I had a head-scratcher the other day. All of a sudden, SQL Server Management Studio stopped showing the cubes in the dropdown of the MDX Query tab although MDX queries and reports would execute just fine. The Reporting Services MDX Query Designer would complain with "No cubes found" error when...
simpleparameters.zip Continuing our intrepid journey in the land of SSRS-SSAS integration, after we've figured out how to retrieve the cube metadata, we are ready to tackle another unchartered territory: query parameters. Issue : You need to parameterize the MDX query by a measure or a simple parameter...
An interesting question popped up on the discussion list the other day about how to retrieve a list of the cube measures so the report author can display them in a report parameter. Solution 1: If you just need a list of measures but not the measure metadata, such as display folder, etc., you can use...
So many SSAS browsers, so little resemblance... And each browser has an independent view of which SSAS features it cares about and how it will go about implementing them. For example, Excel 2007 will let you use named sets on rows or columns but not as a filter. The cube browser and Report Builder let...
I had to tackle an interesting requirement the other day. A cube had a number of KPIs defined but the threshold values that were used to define the "good", "bad", and "so-so" status ranges had to be defined as configurable values at any level of the organization dimension...
Issue You have a table with pivoted measures, such as: Use the following statement to create and populate the table: CREATE TABLE pvt ( VendorID int , DateID int , MaturityAmount1 int , MaturityAmount2 int , MaturityAmount3 int , RepricingAmount1 int , RepricingAmount2 int , RepricingAmount3 int ); GO...
Issue : You author an SSRS report that connects to a cube. You want to create a calculated member that uses a report parameter. For example, the Selector calculated member in the following query returns 1 if a given employee has exceeded 1 million in sales for the dates specified by the user in the report...