Gentlemen,
It does not have to do with a difference between 4.1.4 and earlier versions
(at least not 4.13 or 4.12). The key here is after you have added the
formula, go back to the first tab and reset the type BEFORE you OK. If you
do not, you will not be able to change it.
Listserv Archives (BOB member since 2002-06-25)
It is really crazy.In formula tab, we should not use mouse to select the
functions and objects. We should simply type the whole formula. You
shouldn’t even change to first tab in between. Complete the formula in one
stretch then goto first tab, change it to ‘Measure’. It works. But you can
never change the formula again. If you try to change it, Object type will
change to ‘Measure’ and we can’t change it back.
On the other hand, though we could create the object as Dimesion, it does
not work. My formula is, “=Count()”. When I try to use this
variable in report, it displays ‘#MULTIVALUE’ error.
Does it mean, we can never use aggregate functions in dimension object? Is
that why BO automatically disables the First tab after setting object type
to Measure?
–Vasan
-----Original Message-----
From: Charles Killam [SMTP:ckillam@BUSINESSOBJECTS.COM]
Sent: Monday, February 01, 1999 3:50 PMGentlemen,
It does not have to do with a difference between 4.1.4 and earlier
versions
(at least not 4.13 or 4.12). The key here is after you have added the
formula, go back to the first tab and reset the type BEFORE you OK. If
you
do not, you will not be able to change it.-----Original Message-----
Sent: Monday, February 01, 1999 4:32 PMVasan,
Are you sure? I just tested it and it worked fine. Perhaps it has
something to do with the version you are running on. We are on 4.1.4.
This
might be an issue with earlier versions. Sorry I couldn’t help.-----Original Message-----
From: Balagurusamy.Srinivasan@ERCGROUP.COM
Sent: Monday, February 01, 1999 1:34 PMImportance: High
Neil:
We tried that. But once we enter the formula for the variable, BO
automatically changed the object to measure and disabled all the controls
in
the first tab. So we couldn’t change the type to measure–Vasan
-----Original Message-----
From: Buranakanchana, Neil [SMTP:NBURANA@SPSPAY.COM]
Sent: Monday, February 01, 1999 11:30 AMYou can create a variable and force the measure to a dimension. create
a
blank column. rightclick on it and go to “variables” and NOT edit
formuala.
once in, in the first tab type the name of the variable, go to the
second
tab and insert the name of the measure object you want. this is the
kicker,
before you say ok, BO automatically changed the object to be a measure.
go
back to the first tab and for the dimension. you should now be able to
do
a
break on this column. hope this works for you, i haven’t tested it.
Pls report bounces in response to postings to
BUSOB-L-Request@listserv.aol.com
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in
BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
Listserv Archives (BOB member since 2002-06-25)
Hello,
We are trying to use Business Objects as our reporting tool. In our reports we are using 8 diffrent filters to run a report (that we are using it through a drill mode), one of the requirements we got from our customers was that he would like to see list of criterias or filters he used to run the report displayed as a seperate text. For example Cycle plan Report by CBG by Director for the the year 2000 etc… CBG, Director and year would be the values chosen by the customer. This list gets populated dynamically based on the criteria the user selects. Any suggestions on this can be done will highly appreciated.
Thanks.
Nirmala
Listserv Archives (BOB member since 2002-06-25)
Hi Nirmala,
If you set up your conditions as prompts, you can use the UserResponse function to display the conditions in free-standing cells on your report. The function is found under the data provider functions folder. If you select the function, then press help, the syntax for the function will be displayed.
I hope this helps.
John MacGillivray
john.macgillivray@fmr.com
From: Nirmala Varanasi [SMTP:nvaranas@FORD.COM] Sent: Friday, July 13, 2001 8:37 AM
Hello,
We are trying to use Business Objects as our reporting tool. In our reports
we are using 8 diffrent filters to run a report (that we are using it through a drill mode), one of the requirements we got from our customers was that he would like to see list of criterias or filters he used to run the report displayed as a seperate text. For example Cycle plan Report by CBG by Director for the the year 2000 etc… CBG, Director and year would be
the values chosen by the customer. This list gets populated dynamically based on the criteria the user selects. Any suggestions on this can be done
will highly appreciated.
Thanks.
Nirmala
Listserv Archives (BOB member since 2002-06-25)
Thanks a lot for your response. Unfortunately it is not a prompt. There are 8 drop down for the values and the user selects those values and gets the sliced report to meet his criteria. I hope this helps.
Thanks
Sincerely,
Nirmala Varanasi
PIC Lead Analyst
Phone: (313)390-6734
email: nvaranas@ford.com
Listserv Archives (BOB member since 2002-06-25)
In a message dated 7/13/01 9:06:35 AM Central Daylight Time, nvaranas@FORD.COM writes:
Thanks a lot for your response. Unfortunately it is not a prompt. There are
8
drop down for the values and the user selects those values and gets the sliced report to meet his criteria. I hope this helps.
Create an empty cell at the top of your report. Highlight this cell, then select Insert + Special Field + Drill Filters from the menu bar. That will create a dynamic formula that changes as the user drills.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
Can anyone give me a brief overview of the non BO products, Microstrategy, IBI, Crystal Decisions?
Listserv Archives (BOB member since 2002-06-25)
Thank you so much for this post! I was experience as MULTIVALUE error and forgot to change the variable type…
ldcaudle (BOB member since 2005-10-04)