Skip to Content
0
Former Member
Apr 29, 2010 at 09:50 PM

MDX syntax for Essbase using @prompt

59 Views

Hi All,

I've got a situation where I need to select some data from an Essbase environment based on multiple criteria for use in Webi. The requirement is as follows: 1) Select current and previous 2 years of actual data, and 2) Select Current year budget data. I need to combine these two criteria into a single record selection because I need to create a single chart for the data, and trying to create multiple queries and merge the results in Webi has been troublesome. any thoughts? Is this possible? (For the moment I'm not worried about specific names, etc - I'm just curious if it is possible.)

Just as a first observation from my work so far, the @prompt logically needs to be using a numeric value, so I can subtract two years to get my start year, but I seem to be having a problem converting the numeric response to a text string that works for the query. Suggestions?

Thanks

Jim