none
Drill through actions will invoke each other?

    Pregunta

  • I have a meaure group [Sales].

    There are two drill through action on [Sales].

    Drill through action 1:

    There is a C# function which will insert a row into the database.

    Drill through action 2:

    It's a test function. The action is link to a URL and there is no logic in it.

    Here comes a very wired problem. When I call the action 2, a new row will also be inserted into the Database.

    Can someone explain this issue?

    jueves, 21 de junio de 2012 3:00

Respuestas

  • How is your C# code deployed? Is it a .Net Stored Proc in SSAS?

    Have you tried running a profiler to see what calls are being made?

    It's possible that SSAS is doing a "prepare" call to the C# code to try to figure out what shape of resultset is going to be returned.


    http://darren.gosbell.com - please mark correct answers

    • Marcado como respuesta Eileen Zhao lunes, 09 de julio de 2012 2:35
    viernes, 22 de junio de 2012 6:49
  • Please do describe exactly how you have your actions setup, with as much detail as possible. And include the C# code, too.

    I agree with Darren it could be the prepare or something like that.

    One other thing to be aware of is that on a rowset action (which I'm assuming you're using for action 1) the main expression is supposed to return a string, and the string it returns should be a MDX/DRILLTHROUGH query that the client tool will execute. So depending on how you have your action setup, it may be running the C# code when Excel asks which actions are available for a particular portion of the cube (when you mouse over the Additional Actions menu).


    http://artisconsulting.com/Blogs/GregGalloway

    • Marcado como respuesta Eileen Zhao lunes, 09 de julio de 2012 2:35
    sábado, 23 de junio de 2012 0:54

Todas las respuestas

  • How is your C# code deployed? Is it a .Net Stored Proc in SSAS?

    Have you tried running a profiler to see what calls are being made?

    It's possible that SSAS is doing a "prepare" call to the C# code to try to figure out what shape of resultset is going to be returned.


    http://darren.gosbell.com - please mark correct answers

    • Marcado como respuesta Eileen Zhao lunes, 09 de julio de 2012 2:35
    viernes, 22 de junio de 2012 6:49
  • Please do describe exactly how you have your actions setup, with as much detail as possible. And include the C# code, too.

    I agree with Darren it could be the prepare or something like that.

    One other thing to be aware of is that on a rowset action (which I'm assuming you're using for action 1) the main expression is supposed to return a string, and the string it returns should be a MDX/DRILLTHROUGH query that the client tool will execute. So depending on how you have your action setup, it may be running the C# code when Excel asks which actions are available for a particular portion of the cube (when you mouse over the Additional Actions menu).


    http://artisconsulting.com/Blogs/GregGalloway

    • Marcado como respuesta Eileen Zhao lunes, 09 de julio de 2012 2:35
    sábado, 23 de junio de 2012 0:54