Hello,
I want to put the following condition in a dimension however BO is not allowing me to make it a dimension, it automatically makes it to a measure. What am i doing wrong?
= If (<Order Qty><<Running Recd Qty>) Or (<Order Qty> <<Recevied Qty>) Then "Over" Else "Correct"
Any help appreciated.
nnemani 
(BOB member since 2004-09-28)
I believe whenever you are using an aggregate function such as Sum or RunningSum, etc. in a definition for a local report variable/formula it will automatically become a measure as well - this would be a limitation of Business Objects.
A typical work around would be to create this type of variable as a universe object using SQL code if possible at all.
Another work around would be to export the data from the Business Objects report to a *.csv file/MS Excel spreadsheet and then using that as a data source for another Business Objects data provider - you could use VBA macros to automate this process.
Andreas 
(BOB member since 2002-06-20)
Give it a try :
Can you make as a dimension. or a detail object… in your report variables…
BO_Chief 
(BOB member since 2004-06-06)
Hello,
I actually resolved as per Andreas suggestion by converting it to a universe object and it worked out perfect as I needed.
nnemani (BOB member since 2004-09-28)