Is it pos开发者_运维百科sible to have a attribute hierarchy where the parent doesn\'t always have children? If so, how is this achieved in SQL server Analysis Services?Never mind - found the solution:
We are just setting up a number of SSAS Cubes using pro-active caching and one thing that concerns me is how we will know if cube processing fails.
First, my knowledge of MDX is very limited Basically, I have 2 queries; one with HQ sales per departments and one with stock room sales per departments. I would like to return the results of the depa
I have just started tinkering with MS SQL Analysis Services. For a start, I\'m creating one cube from sales detail table. For the dimensions I have created ProductDim from product master table, Locati
I am very new to MDX and have a basic question. I would like a calculated measure which returns one value for dates less than a specified date, and another value if greater than a specified date. I ha
I have a cube with no cell security configured, and get an intermittent problem with a drillthrough action.The cube has two measure groups: One with accounting transactions from a financials applicati
I\'m actually working on a SSAS Cube using SQL Server Reporting Services. In order to filter a field, I need to use a calculated member which specifically use a parameter.
Hi I\'m new to SSAS and MDX and I need to produce a ssrs report based on an OLAP cube. I can\'t figure out how to display different dimension members on columns and rows.
I have a report in SQL Reporting Services (SSRS) that pulls data from an SQL Analysis Services (SSAS) cube. The Cube has two important dimensions - Time and Activity that are related (it\'s a report o
I have a very simple cube with buying transactions details. dimentions: 1. Time dimension with two hierarchies:
加载中,请稍侯......