Question : I have a fact table with the following columns: WorkerName OrderId NumberOfPackagesPerOrder Note that neither WorkerName nor OrderId […]
Tag: mdx
MDX – Getting the last 6 month Dynamically
Question : I have a Dim table that called DimAccounts. It is describing a User account and the dates that […]
MDX query is SLOWER with warm cache
Question : I have a MDX query that executes faster on cold cache than warm cache. If I ran the […]
Getting formatted MDX values using OPENQUERY
Question : Is there any way to convert a value in MDX to a string using its FORMAT_STRING? I have […]
8000 character limit in OPENQUERY against Analysis Server
Question : I have a query like SELECT column1, column2 FROM OPENQUERY(AnalysisServerName, ‘MDX QUERY …’). It is inside a stored […]
MDX Intersection – how to?
Question : A similar question has been asked here, but I’ll give a brief intro. In SQL Server there are […]
Altering SSAS writeback behavior?
Question : I’m trying to implement a writeback measure group for required quantities by month and part number. I’m puzzled […]
SSAS Calculated Member Conditional Count
Question : I have a table representing Accidents and a column with Accident Severity ranging from ‘Slight’ to ‘Fatal’. I […]
What are the most relevant similarities between T-SQL and MDX?
Question : I have used T-SQL (CTEs, windowed functions, recursive CTEs, large data, table-valued functions, APPLY, PIVOT, stored procedures, etc.), […]
MDX Crossjoin filtering on different hierarchies from the same dimension is very slow
Question : I have an MDX query that was written by an MDX novice that is excessively slow (the query, […]
- 1
- 2