Min and Max values in a variable

rbuser

Hi,
I am trying to put 2 variables in my report based on the selection of
another variable that I filter in the cube. My cube layout is like this:

default cube
|-Cube to build report
|- Report

There are 2 pieces of data that I am concerned with: 1) Day end # and 2) Min
and Max invoice number (range of invoices for that day-end).

My invoice numbers and day-end numbers exist in default cube, but Cube to
build report is filtered furter(on another field altogether) so it doesn't
show all invoice numbers.

What I want to be able to do is have variable in one of the report headers
that displays Min and Max invoice number from default cube based on DayEnd
number selected in Cube to build report.

Is this possible?

Thanks,
Robert

nicocizik

Hi Robert,

Sorry for the delay in this response. I am by no means an expert on the
Decision Cube but if you are able to extract data from one of its cells, you
could possibly load it into a report using a JITPipeline. JITPipelines are
used primarily to retrieve and traverse data that does not exist on a
database but rather in a Delph object or in memory somewhere. For some
examples, please see the ReportBuilder Demo application located in the
RBuilder\Demos\1. Reports\... directory.

--