Stack Overflow
Stack Overflow

Questions tagged [mdxclient]

An ADO.NET data provider for MDX queries

MdxClient is an implementation of a .NET Framework Data Provider, with objects such as Connection, Command, DataReader, DataAdapter, etc. MdxClient is specifically designed to execute MDX queries against SQL Server Analysis Services. It is very similar to the ADOMD.NET Data Provider, with some specialization.

11 questions
4
votes
1 answer

Convert CellSet object to JSON result

I want to convert a CellSet object (which is the result of an MDX query in SSAS) into a valid JSON format which will empower some client side charts. Following is the sample query . SELECT [Measures].[Sales Amount - Reseller Sales] ON COLUMNS, NON…
user3908927
  • 51
  • 2
1
vote
2 answers

Get Top 5 by Different years MDX

I have a top 5 of Customers by year and I want to create a query that gets this information per year in different years at the same time, I mean: select [Measures].[Ventas] on columns, non empty topcount ( [Dim Cliente].[Company…
Antonio Labra
  • 1,694
  • 2
  • 12
  • 21
1
vote
2 answers

Is there a way to specify or force data type of calculated member?

I've got data type of every measure in my cube specified as Currency. I've also got calculated members, some of them have iif(isempty([Measures].[Measure1]) or [Measures].[Measure1] = 0, null, 100 * [Measures].[Measure2] / [Measures].[Measure1])…
Piotr Sobiegraj
  • 1,775
  • 16
  • 26
0
votes
0 answers

Saving MDX query results to Table or csv file

I am not from SSAS background. We are trying to automate a process where we are currently switching multiple filters on excel sheets that are connected to SSAS cubes and do a visual comparison against the data on a Netezza table. Basically, we are…
user9254573
  • 1
0
votes
1 answer

Connect to SAP HANA Database using VBA

I am trying to fetch data into Excel from SAP HANA database using vba. I came across the below questions. Do I need to install SAP HANA MDX Provider for this? If yes, please provide the link. I am unable to spot any. What would be the vba script…
Vikram
  • 65
  • 2
  • 9
0
votes
3 answers

MDX Date Formatting

Can any one please tell me how to format date in MDX queries? We dont use SSRS to generate report ,we have our own customised reporting tool built on SSAS.Date filter sends date in yyyy/mm/dd format . As of now we dont have a date dimension. My date…
Mithra
  • 15
  • 1
  • 8
0
votes
0 answers

SSRS Alpha Numeric value Search

My SSRS report is connected to SSAS. I have a parameter called Plant Code. In data base my plant code is in alpha numeric format like '02plant123'. Wen i search the report with a plant code the following error occurs 'plant123' not fount and by…
Mithra
  • 15
  • 1
  • 8
0
votes
1 answer

Better syntax for MDX

if there a better way to write the MDX SELECT { [Measures].[Label], NonEmpty [Measures].[UniqueName], NonEmpty [Measures].[TargetName], [Measures].[Place] } ON COLUMNS , NON EMPTY …
Nomitha patel
  • 1
0
votes
1 answer

How to convert xsd:double string to decimal in one step

I'm using MdxClient which internally parses XML documents returned by AdomdCommand.ExecuteXmlReader. Some of values are returned as xsd:double, but I want them as decimal at client side. This library to parse values uses Convert.ChangeType method.…
Piotr Sobiegraj
  • 1,775
  • 16
  • 26
0
votes
1 answer

get userFriendly names of dimmension attributes in mdx

I'm using the MDXClient library in my C# application. I browse cube and generate some reports based on mdx queries. When I use Management Studio I have nice (user friendly) column names in the query result, but when I use this library the column…
gruber
  • 28,739
  • 35
  • 124
  • 216
-1
votes
1 answer

I need a quick help on the below mdx query

I want to filter the data on the measure and dimension at a time case when [measure].[frequency] >3 and [poa].[segment].&A then 'red' when [measure].[frequency] <3 and [poa].[segment].&A then 'yellow' when [measure].[frequency] =3 and…
Adi
  • 232
  • 1
  • 9