Hello List –
I’m using BO ver 4.1. I’ve built a query where the user inputs the start date for a given Object . I’ve been trying to capture the START date to use as a controlling variable. I was given the following guidance from a fellow “lister”:
@Variable(‘Var’) = @Variable(‘Var’)
Then refer to the variable as – =
UserResponse(DataProvider(), “Var”).
This appeared to do the job, with the exception of one problem. The variable definition could NOT be seen in the Slice and Dice Mode, yet was visible when viewing the variable list (Format - variables) under BY DATA PROVIDERS in the COMMON Folder. Does anyone know how to use variables in the COMMON folder??? Thanks in advance for any assistance provided.
Craig Stark
g GE Electrical Distribution & Control
I’ve built a query where the user inputs the start date for a given
object.
I refer to the variable as
=UserResponse(DataProvider(),“Var”).
The variable definition could NOT be seen in the Slice and Dice Mode, yet was visible when viewing the variable list (Format - variables) (in
folder COMMON)
The variable you created for the user response is not linked to any other dataproviders
(it does not have a common dimension object). This is the reason it is not visible in the slice & dice,
they are not compatible. You can however use these variables by inserting them from the variable list
into e pre-made cel (this you do in the WYSIWYG editor). The page headings and footers and global report header and footer area are ‘valid’ places for these variables.
If by chance you wish to put it in a master or detail section with a different ‘master’ object,
you will have to resort to a max() function around the variable to get rid of the #MULTIVALUE.