Skip to Content
0
Former Member
Apr 22, 2009 at 07:29 PM

*WHEN and STORED PROCEDURES

14 Views

Hi there!

I have a transformation group in a stored procedure type account transformation that i would like to fire only lets say when TIME.MONTHNUM = 1 2 or 3. (basically 1st quarter).

Here is what the book says:

Stored  procedures  must  be  written  in  their  own  commit  section, 
 i.e.  they  cannot  coexist  with  a  WHEN/ENDWHEN  structure, 
nor  can  be  part  of  any MDX  logic.  

What is the workaround? (i still wanna use the BR)

Thanks for your help

Nic