Skip to Content
Former Member
Apr 07, 2011 at 08:16 AM

Problem with Calculation with Bex Query


I am facing problem when I try to perform any calculation of measure or creating a variable in WEBI which sum the Sales quantity.

when i try to select any measure and goto Insert ->Calculation menu all the options are disable

I try to create the variable from the formula which sum the billed qty and after adding it to the blank cell run the report it gives me the error as following.

A database error occured, The database error text is : The MDX query Select { Measure].[DAxxxxx] ON column, non empty xxxxxxxxx. failed to execute with the error Unknown error when executing MDX.

Please let me know that cacluation works with bex query as it works with normal data base.

Kind regards,