BO v5.1, ORACLE database - standard crosstab formatting question. The row header and Column header are both dimensions. I have defined my cell as a Character variable and used the Max function to get single row per dimension. That works but all my cells, other than those having a number value, are concatenated with a leading 0. Also, any string starting with a number gets truncated from the first alpha onwards.
e.g.,
User1 User2 User3
Name 0JDoe1 0JDoe2…
Address 200 (Rest is alpha and gets truncated.)
City 0Albany
Phone No. 9999999
I think I reported a similar problem last week, and I didn’t really get an answer.
But, I think your problem can be solved… If you check the format tab of your report, you can change the format clauses on your text fields - they are probably 999 (or something similar)…
My issues was that my year in the heading would get printed as a percent, but I think that the crosstab takes detail field and uses that format clause. It will also reset to that clause after an edit / reformat…
Brent
Hi All,
BO v5.1, ORACLE database - standard crosstab formatting question. The row
header and Column header are both dimensions. I have defined my cell as a
Character variable and used the Max function to get single row per dimension. That works but all my cells, other than those having a number
Yes, I did check the display format thru’ Format → Cell and it is Standard.
Thanks,
Swati.
I think I reported a similar problem last week, and I didn’t really get an answer.
But, I think your problem can be solved… If you check the format tab of your report, you can change the format clauses on your text fields - they are probably 999 (or something similar)…
My issues was that my year in the heading would get printed as a percent, but I think that the crosstab takes detail field and uses that format clause. It will also reset to that clause after an edit / reformat…
Brent
Hi All,
BO v5.1, ORACLE database - standard crosstab formatting question. The row
header and Column header are both dimensions. I have defined my cell
as a
Character variable and used the Max function to get single row per dimension. That works but all my cells, other than those having a number
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
If you can create a view (or table) that lists beginning of each month, you could run the following SQL and do a crosstab in Bus Obj.
Please let me know if questions.
Andriy Mysyk
WCI Consulting
SELECT month.full_date
your_data.group,
MIN(your_data.volume)
FROM your_data,
month
WHERE your_data.start_date BETWEEN month.full_date AND ADD_MONTHS(month.full_date, 1)
OR your_data.end_date BETWEEN month.full_date AND ADD_MONTHS(month.full_date, 1)