In your Designer module, right click on the object you want to format. One of the options will be ‘Object Format’, select it and you can format the object as you want it!!!
From: Edna Lee [SMTP:Edna_Lee@SWISSRE.COM] Sent: Monday, July 27, 1998 11:43 AM
Hi again,
I heard somewhere that there is a way in BO 4.1 to permanently format a
cell to display the way we would like to see. Like for example, I would like all my number datatype objects to default
the cell format to 0, instead of #,##000 eg. It is currently displaying the reports like this: Accident Year
1,992
1,993
1,994…
Is there a way to default to display like this: Accident Year
1992
1993
1994…
I heard somewhere that there is a way in BO 4.1 to permanently format a cell to display the way we would like to see. Like for example, I would like all my number datatype objects to default the cell format to 0, instead of #,##000 eg. It is currently displaying the reports like this: Accident Year
1,992
1,993
1,994…
Is there a way to default to display like this: Accident Year
1992
1993
1994…
In your Designer module, right click on the object you want to format. One of the options will be ‘Object Format’, select it and you can format the object as you want it!!!
I heard somewhere that there is a way in BO 4.1 to permanently format a
cell to display the way we would like to see. Like for example, I would like all my number datatype objects to default
the cell format to 0, instead of #,##000
…
Any help is appreciated.
Thanks,
Edna
Maybe someone here might be able to help me on a particularly thorny problem:
What I have is a correlated subquery involving a calculation. I’ve simplified the problem in the following SQL:
SELECT
LEAD.ID, LEAD.OWNER, FORECAST.STAGE
FROM
LEAD, FORECAST
WHERE
(LEAD.ID = FORECAST.ID) AND
FORECAST.STAGE = ‘WON’ AND
FORECAST.STAGE_DATE = ALL
(
SELECT MIN(fc_alias.STAGE_DATE)
FROM FORECAST fc_alias
WHERE fc_alias.ID = LEAD.ID AND
fc_alias.STAGE = ‘WON’
)
In this case we store the STAGE_DATE as a truncated date so it’s entirely possible that we have more than record from the forecast table with the same ID and STAGE_DATE, but different STAGE’s (therefore the necessity for qualifying on STAGE in both the outer and inner queries).
The question is - How do we accomplish this in BO without resorting to modifying the query by hand? Is there a transformation here that would not require a subquery?
BO does not allow us to qualify on a field when we create a calculation.
If we get tricky and enter the qualification within the Designer (or create a subquery and return a calculation), BO does something else which I simply don’t understand. When we try to construct a correlated subquery without using the calculation wizard, BO adds the table in the outer query into the inner query. When I try to create the above query, BO will produce the following:
…
(
SELECT MIN(fc_alias.STAGE_DATE)
FROM FORECAST fc_alias, LEAD <------ notice the LEAD table here
WHERE fc_alias.ID = LEAD.ID AND
fc_alias.STAGE = ‘WON’
)
This foils the query because Oracle apparently reads this as a different instance of the table.
Any ideas? This post was rather long, thank you for your patience.
You can add to your databases parameter file and use a ‘custom’ date format.
I would add an object along the lines of: to_date(to_char( TABLE.COLUMN, ‘mm/dd/yyyy’),‘m/d/yyyy’)
Bring in this object and just change the Table.Column to match your database. You can customize this by imitating the list of available formats in your particular database format.
(While not the prettiest, it makes sure that the date values are always in the same format)
Manoj - You are now a god in my book. Thanks. I can’t tell you how long that has frustrated me.
At 04:53 PM 7/28/98 -0500, you wrote:
Joseph,
I am not fully clear about what you are doing but I remember encountering similar problem. instead of a subquery you can create a condition object in the designer itself as follows:
…
Manoj
Joseph Stiehm
Cisco Systems
7025 Kit Creek Road
P.O. Box 14987
Research Triangle Pk, NC 27709-4987
(919)472-2228 or (800)888-8187 x22228 jstiehm@cisco.com
