#IERR message

building reports desktopintelligence
1

Hello Listers,

Just like a #COMPUTATION or a #MULTI-VALUES message, what could be the reasons behind getting a #IERR message and how best to avoid it ( the #IERR )?

Thanks in advance.
Regards,

Unni

Listserv Archives (BOB member since 2002-06-25)

2

I’ve gotten this message before when I have a variable that I’m using that’s referencing another variable that is not visible in the report and is not on the pivot tab.

To avoid it, at least make sure that all variables that you’re referencing are in your pivot tab even if they are not visible on your report tab.

Julie Neumann

Hello Listers,

Just like a #COMPUTATION or a #MULTI-VALUES message, what could be the reasons behind getting a #IERR message and how best to avoid it ( the #IERR )?

Listserv Archives (BOB member since 2002-06-25)

3

Thanks Julie.
I will try that, which I have not earlier, and see.

Thanks & Regards,

Unni

I’ve gotten this message before when I have a variable that I’m using that’s
referencing another variable that is not visible in the report and is not on
the pivot tab.

To avoid it, at least make sure that all variables that you’re referencing
are in your pivot tab even if they are not visible on your report tab.

Julie Neumann

Hello Listers,

Just like a #COMPUTATION or a #MULTI-VALUES message, what could be the reasons behind getting a #IERR message and how best to avoid it ( the #IERR )?

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!):
listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================

Listserv Archives (BOB member since 2002-06-25)

4

Unni,

The reason that you are getting that error is because you are using two variables to come up with a result. You are either adding two variable or you are spreading out data.

Solution:

In the variable that you are using, you need to use all context of all variables. For example, if your first variable is make up of Premuim,date, and inception, then what you need to do is bring all of those piece of the variable ((Premium+Date+inception)+ you new variable. This way you are adding all components of the first variable.

Regard

Aris

Listserv Archives (BOB member since 2002-06-25)

5

Unni,

I have come across three reasons where you can get #IERR - usually with formula within formula.

Firstly ther are formulae that combine dimensions and measures but the dimension is not in the calculation context. In this case add the dimension to the context.

Secondly there are aggregates (e.g. Sum, Min, etc) that contain multiple formulae.

Thirdly you might have a formula with a complex WHERE clause.

In cases 2 and 3 create a named variable, say my_var, then create a new formula based upon my_var e.g. =Sum(<my_var>) or =<my_var. WHERE (=“value”)

Hope this helps,

Steve

Listserv Archives (BOB member since 2002-06-25)