I have a report using 5 freehand SQL queries in BO 4.0.5 running against
SQL Server 6.5. One of those queries is returning rows containing fees.
I created a variable to aggregate these fees into a total which I want
to add to other costs to get a grand total. The fees show up fine (they
are dimensions) and the totalfee variable works fine in the same section
as the fees. However, the total cost is in a different section based on
a different query. The totalfee variable gives me an #IERR when I try to
insert it into this section.
I have tried using “IN BODY, IN BLOCK, and IN REPORT” as qualifiers for
this totalfee variable. How can I use this variable in a different
section?
In a message dated 99-03-01 10:36:43 EST, you write:
The fees show up fine (they
are dimensions) and the totalfee variable works fine in the same section
as the fees. However, the total cost is in a different section based on
a different query. The totalfee variable gives me an #IERR when I try to
insert it into this section.
Without seeing the actual query structure, I can only guess. But I suspect
that your numeric values should be measures rather than dimensions. When you
have variables / query objects defined as dimensions, there are restrictions
as to what you can do with them across different query blocks. Measures have
much more flexibility.
Of course, you will need to have defined proper links between your five
different free hand SQL data sets. Otherwise your totalfee object will “roll
up” to a grand total, rather than being at a detailed level. I suspect that
you want detailed computations so you can compare totalfee to totalcost.
I have a report using 5 freehand SQL queries in BO 4.0.5 running against
SQL Server 6.5. One of those queries is returning rows containing fees.
I created a variable to aggregate these fees into a total which I want
to add to other costs to get a grand total. The fees show up fine (they
are dimensions) and the totalfee variable works fine in the same section
as the fees. However, the total cost is in a different section based on
a different query. The totalfee variable gives me an #IERR when I try to
insert it into this section.
This is quite clear: you will get 5 microcubes which, by default, are “unlinked”.
This means that you cannot disply a measure
from one of the queries along with dimensions from another query.
What you have to do is to “link” the cubes on the common dimensions, then you will
be able to disply measures from linked cubes together with the linked (i.e common)
dimensions.
Hope this helps
Walter
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at