Try leaving the variable as a measure and setting the associated function to none. This may give you the behavior you desire.
Robert
Schmidt Interactive Software, Inc.
I have defined a variable (studiepunten) as follows:
=Sum( In (,, ) In )
When I define the variable BO automatically turns it into a measure. I want to group the results and turn the grouping into a dimension for using in a crosstab.
Because BO turned the variable into a measure I can’t use the derive option.
After you get one row, go to ‘View Data’ box (it is the cube button on your general toolbar). On the left side of this screen, you have the objects.
You have 2 tabs on the right side of this screen. 1) Click a measure object from the left side of the screen. 2) Go to definition tab on the right side of the screen. 3) Change the object type to dimension.
4) Repeat this for all neccessary objects.
After you get one row, go to ‘View Data’ box (it is the cube button on your general toolbar). On the left side of this screen, you have the objects.
You have 2 tabs on the right side of this screen. 1) Click a measure object from the left side of the screen. 2) Go to definition tab on the right side of the screen. 3) Change the object type to dimension.
4) Repeat this for all neccessary objects.
I can’t, all options are grey. Anyway the original object is a dimension, the variable I create in my report bases on this dimension automatically turns into a measure.
After you get one row, go to ‘View Data’ box (it is the cube button on
your
general toolbar). On the left side of this screen, you have the objects.
You have 2 tabs on the right side of this screen. 1) Click a measure object from the left side of the screen. 2) Go to definition tab on the right side of the screen. 3) Change the object type to dimension.
4) Repeat this for all neccessary objects.
–
I can’t, all options are grey. Anyway the original object is a dimension,
the
variable I create in my report bases on this dimension automatically turns
into a
measure.
In a message dated 98-07-01 06:48:21 EDT, you write:
Hi,
I have defined a variable (studiepunten) as follows:
=Sum( In (,, ) In )
When I define the variable BO automatically turns it into a measure. I want to group the results and turn the grouping into a dimension for using in a crosstab.
[ snip ]
Desiree Schipper
… and the responses …
In a message dated 98-07-01 11:48:32 EDT, you write:
This solution works for personal data files. Desiree, did you try changing
the qualification function to none?
After you get one row, go to ‘View Data’ box (it is the cube button on
your
general toolbar). On the left side of this screen, you have the objects.
You have 2 tabs on the right side of this screen. 1) Click a measure object from the left side of the screen. 2) Go to definition tab on the right side of the screen. 3) Change the object type to dimension.
4) Repeat this for all neccessary objects.
I have defined a variable (studiepunten) as follows:
=Sum( In (,, ) In )
When I define the variable BO automatically turns it into a measure. I want to group the results and turn the grouping into a dimension for using in a crosstab.
Because BO turned the variable into a measure I can’t use the derive option.
When I try to create a grouping myself as follows:
= If Between (0,20) Then “0-20” Else “anders”
BO keeps defining the result as a measure instead of giving me the option to make a dimension out of it. So I still can’t use the result in a crosstab.
Does somebody have an idea how to turn it into a dimension.
BTW I’m using BO 4.1 on an oracle database (7.3.2).