How to get measure value from cube using c# code

Question

I am writing code in c# where i want to retrieve measure value and date from cube. I have written below code.

public class cubeData
{
    public void getData()
    {
        AdomdConnection con = new AdomdConnection("Data Source = <serverName>; Initial Catalog = <dbName>");
        con.Open();
        string command = @"Select [Measure].[Foo] on ROWS, [Date].AllMembers on Columns From SalesCube";
        AdomdCommand cmd = new AdomdCommand(con, command);
        AdomdDataReader dr = cmd.ExecuteReader();

        While(dr.Read())
        {
            Console.WriteLine(Convert.ToString(dr[0]);
        }
        dr.Close();
        con.Close();
    }
}

This code returns only date not measure value correspond to the date. Any suggestion would be very helpful.

Thanks in advance

userfl89 · Accepted Answer · 2018-09-14 14:28:16Z

1

Try using Console.WriteLine(Convert.ToString(dr[3]) to get the measure value. I'm not sure if you're using a Tabular/Multidimensional cube or what compatibility level you're at, but I'm able to access measure data from a Tabular cube at compatibility level 1200 using an MDX command that returns an equivalent result set.

edited Sep 14, 2018 at 14:28

answered Sep 14, 2018 at 13:58

userfl89

4,8201 gold badge13 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MrHappyHead · Accepted Answer · 2018-09-17 12:07:42Z

0

It's been a while since I've done it but you may need to flatten out the data in the resultset returned. The data could be split across different axes that you may have to iterate over.

answered Sep 17, 2018 at 12:07

MrHappyHead

4423 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to get measure value from cube using c# code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related