5 Replies - 290 Views - Last Post: 05 November 2017 - 08:24 PM Rate Topic: -----

#1 joeystyles  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 24-October 17

Pivot like table in C# from analysis services

Posted 05 November 2017 - 11:35 AM

Hi all,

I have created a SQL database and a cube, I would like to create a pivot like table in my C# application based off this data.

Here is an extract:

Customer Material Sales Qty
A 159543 10 2
A 159547 20 4
B 159543 15 6
C 156678 16 8
D 168889 18 1
E 172345 19 2
F 563626 20 3

My cube already has all of the aggregations and measures built in.

I have tried using reportviewer, which isn't really suitable because I want the table to be interactive.

First question: How should I connect to my data? Via database or the analysis services cube? - I would of thought the cube would be quicker?

Second question: What method can I use to create a pivot like table? So being able to drill down etc.

I am using C# WPF app.

Thanks for your help in advance and let me know if you have any questions to help make it clearer.

Many thanks,
Joe

Is This A Good Question/Topic? 0
  • +

Replies To: Pivot like table in C# from analysis services

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13482
  • View blog
  • Posts: 53,820
  • Joined: 12-June 08

Re: Pivot like table in C# from analysis services

Posted 05 November 2017 - 11:54 AM

Report builder with Reporting Services is pretty nice for drill down reports. I assume there's third party tools as well.

Ex:
https://docs.microso...ed-data-regions

https://docs.microso...uilder-and-ssrs
Was This Post Helpful? 0
  • +
  • -

#3 joeystyles  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 24-October 17

Re: Pivot like table in C# from analysis services

Posted 05 November 2017 - 12:54 PM

Hi,

Thanks for that, they do look really good. Do you know if I will have to use reporting services with this or can I link it directly into a multidimensional cube?

Thanks for your help.

Many thanks,
Joe
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13482
  • View blog
  • Posts: 53,820
  • Joined: 12-June 08

Re: Pivot like table in C# from analysis services

Posted 05 November 2017 - 01:07 PM

You can certainly investigate that and report back!
Was This Post Helpful? 0
  • +
  • -

#5 joeystyles  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 24-October 17

Re: Pivot like table in C# from analysis services

Posted 05 November 2017 - 05:23 PM

Unfortunately it looks like a stand alone app so I can't use it in my application. What about just using a datagrid? And then setting events manually to pull in the data?
Was This Post Helpful? 0
  • +
  • -

#6 snoopy11  Icon User is offline

  • Engineering ● Software
  • member icon

Reputation: 1375
  • View blog
  • Posts: 4,307
  • Joined: 20-March 10

Re: Pivot like table in C# from analysis services

Posted 05 November 2017 - 08:24 PM

You can do it with a cube but you would need third party tools price $299

https://www.nrecosit...gated-data.aspx
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1