Jump to content

How to handle "No such tuple" in MDX query ?


Exie

Recommended Posts

Hi,

I have a report I'm making which passes a parameter into an MDX query. It's a sales report, and when I use one sales rep, it works cool, but when I use a new sales rep who doesnt have any sales for last month, I get:Error filling print... No such tuple ([Measures].[Prior MTD Sales] on axis 0.

The measure is defined as: 

member [Measures].[Prior MTD Sales]  as='Sum(Mtd(ParallelPeriod([Time].[Year], 1.0, $P!{FullDateSelection} )), [Measures].[Total Value])', format_string = "|$#,###.00|"

I know there will be no data for the particular rep, can I just get it to return blank or null or something rather than erroring out ?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...