mdx
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 分类:问答Getting data for past 6 months in MDX
I am using SSRS to create reports. For the metrics i am pulling out data from the analysis services. I want to modify the mdx query created by the query designer to include data only from past 6 month[详细]
2023-03-01 16:51 分类:问答Schema-agnostic OLAP-like tool?
Do there exist any (ideally free or open-source) tools for performing OLAP analyses on arbitrary tables in a relational database, without requiring any advance specification of dimensional hiera开发者[详细]
2023-02-27 08:13 分类:问答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 分类:问答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 分类:问答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 分类:问答How to Unproject in SlimDX
I am new to game programming as well as new to DirectX & SlimDX. Currenty I am converting a MDX code to SlimDX code and I got stuck into an issue which I am unable to find out in the SlimDX docume[详细]
2023-02-22 23:47 分类:问答How to create a calculated member based on two measures and the hierarchy level of the queried dimension's current member?
I have a cube which has two measure members: [Measures].[Value] (integer) and [Measures].[EffectiveBelowLevel] (integer).[详细]
2023-02-21 21:56 分类:问答paging in mdx query
Hello i am giving row numbers to result using rank in m开发者_如何学运维dx expression,now how can i restrict no. of rows retrieved that is i want first 10 rows and then i want another 10 rows and so o[详细]
2023-02-20 19:02 分类:问答