We have a bunch of reports, and intend to alter them in the following way. We add additional dataproviders. One that we (using VBA) fire off before the main queries retrieve data, and one we fire off afterwards. Both these providers retrieve two fields: A numeric field and a datetime field.
The idea is that if the numeric field (which holds a version number) changed between start and end, we know the database has been reloaded, and therefore we want to hide all the data on the report.
Seems easy enough. I added a new measure, and used a function to compare the start value to the end value, and if the same, set it to 1.
However, when I try and read what’s in the field, I get a #COMPUTATION error. I checked, and the fields are equal.
In WebI, i solved this by merging both the fields. In DeskI, I cannot seem to be able to handle this properly, despite having linked the two objects.
The dimensions I use are a numeric field indicating which database partition is currently active for reporting, and a datetime field detailing when the last switch occurred.
I created the two in my universe as Dimension objects, and added them to my dataproviders.
The formula I am trying to use, I created as a dimension object (if I create it as a measure, my alerter in the header fails to work) in the report, and it has the following formula:
= If (<Seamless Current Partition(System Data End)>=<Seamless Current Partition(System Data)>) Then 0 Else 1
As you can see, the formula is pretty straightforward. If the value of the numeric field did not change, the variable takes the value of 0, and else it becomes 1.
I was planning on using the variable as the criteria in the hiding section, but this does not work. When dragging the variables onto a seperate subreport, created purely for debugging purposes, I see the cell’s content showing as “#COMPUTATION”. I also tried creating measure objects and basically having them take on the value of the Seamless Current Partition field, but that leads to #IERR errors.
If I get this correctly the object Seamless Current Partition can only have one value in each of the two queries, is that correct?
Its only dependent on the current state of the database?
If so, I would have used a measure object in the query iso a dimension object.
Measure objects are automatically ‘compatible’, no need to ‘link’ the two dimension objects.
Set the report aggregation(second tab in the object definition) of the measure object to min() or max().
Using the min() or max() in the report itself will probably not work
because BO knows there are two incompatible dimension objects used in the formula.
(BOB member since 2004-06-06)
(BOB member since 2002-08-20)