We are using RADPIVOT grid connected to our SQL Server 2014 Analysis server. What we want to be able to do is create session based calculated fields from the C# client. I can create these session based calculated fields using an MDX query however as they are session based only I need to be able to create them using the same connection as the ADOMDDataprovider does so they will be visible and selectable in the RADPivotField List. I want them to be session based as I want them to disappear once the connection is closed.
I was hoping that the ADOMDDataprovider class actually exposed an ADOMD Connection and then I could just send my MDX query via a ADOMD Command down this connection however as far as I can see is does not seem to expose this.
Have you any ideas how this may be possible.?
Thanks
I was hoping that the ADOMDDataprovider class actually exposed an ADOMD Connection and then I could just send my MDX query via a ADOMD Command down this connection however as far as I can see is does not seem to expose this.
Have you any ideas how this may be possible.?
Thanks