Drill through actions will invoke each other?
-
jueves, 21 de junio de 2012 3:00
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?
Todas las respuestas
-
viernes, 22 de junio de 2012 6:49Moderador
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 ZhaoMicrosoft Contingent Staff, Moderator lunes, 09 de julio de 2012 2:35
-
sábado, 23 de junio de 2012 0:54Moderador
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).
- Marcado como respuesta Eileen ZhaoMicrosoft Contingent Staff, Moderator lunes, 09 de julio de 2012 2:35
.png)
