ssas
Analysis Services Attribute Hierarchy and Attribute Relationships
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:[详细]
2023-03-02 18:19 分类:问答Automatic MOLAP Error Notification
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.[详细]
2023-03-02 17:44 分类:问答Multi select on same MDX query
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[详细]
2023-03-01 18:10 分类:问答OLAP dimension for boolean, time, selective count
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[详细]
2023-02-27 06:59 分类:问答IIF in With Member comparing dates
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[详细]
2023-02-26 20:00 分类:问答Misleading cell security error message prevents drillthrough action on SSAS2008
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[详细]
2023-02-26 17:44 分类:问答How to pass multivalues parameters in MDX calculated members?
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.[详细]
2023-02-26 04:29 分类:问答Display different dimensions on columns and rows with SSAS and MDX
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.[详细]
2023-02-25 17:20 分类:问答SSRS Report Based on Query from SSAS Runs much slower than cube browse in SSAS
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[详细]
2023-02-23 08:37 分类:问答MDX query problem (count measure over specific time range)
I have a very simple cube with buying transactions details. dimentions: 1. Time dimension with two hierarchies:[详细]
2023-02-23 06:21 分类:问答