MDX query based on list from another query - social.msdn.microsoft.com
Jun 23, 2008 · I am trying to filter a query based on a list of numbers from another query. What we have is a cube with Client Record Numbers (CRN's) in one dimension and Service Codes in another …
Save an MDX Query - social.msdn.microsoft.com
May 24, 2023 · MDX is the query language for SSAS database, just like T-SQL is the query language for SQL Server database. You just need to use the correct tools. >>>The reason we're doing Excel right …
How to view MDX query from Excel report - social.msdn.microsoft.com
Apr 7, 2006 · I generated OLAP report from SQL Server Analysis server using Excel. When you are using Excel to generate a report from OLAP database, excel will take care of generating the required …
How to union 2 MDX query results from 2 cubes
Dec 3, 2015 · The other "slightly hacky" option is to create a linked server to SSAS in SQL Server then you can run the two MDX queries using OPENQUERY () and union the results from there.
Query multiple cubes in a single MDX? - social.msdn.microsoft.com
Jun 2, 2010 · I am wondering if there is a way to query more than one cube in a single mdx statement. Here's the deal - I have a cube that has a measure group that is a count of invoices, and another …
Subquery for measure in MDX - social.msdn.microsoft.com
Nov 29, 2009 · The easiest way to create an MDX query is by using the Query Designer (OLAP datasource ) in SSRS Report Wizard.
OpenQuery and MDX - social.msdn.microsoft.com
Aug 18, 2010 · I have an MDX query which takes approx 8 mins to execute. Then Further i want the result of this MDX query into SQL table, hence i used OpenQuery but this is taking huge amount of …
MDX query to filter values greater than zero with YTD Function
Apr 24, 2019 · I want to filter the data with values greater than zero for YTD Function and below query gives me null values. How do I filter the values above zero. I know function Filter, NonEmpty, IsNULL …
MDX query for parent-child data - social.msdn.microsoft.com
Sep 13, 2012 · Dim_Product_Hier contains the the above mentioned product hierarchy in Parent child relationship, similarly Dim_Date_Hier. Reason being users will feed target sales for any combination …
How to write calculations for CurrentWeek,CurrentMonth, Current …
Feb 3, 2016 · I need to write the MDX Expressions to calculate the [Incident Count] for CurrentWeek,CurrentMonth, Current Quarter.