Sitemap

Amicuk Programming Answers

Decimal Places in Pivot table

2015-10-11   Views:1

Advertisement

Hi Gurus, When I create a pivot table with a measure and I choose "Show Data as ... percent of something (for example section) I get the result with 1 Decimal Place. How to modify it for 2 or more Decimal Places? Thanks LaszloHi Laszlo! We have found

Hi Gurus,
When I create a pivot table with a measure and I choose "Show Data as ...
percent of something (for example section) I get the result with 1 Decimal Place.
How to modify it for 2 or more Decimal Places?
Thanks
Laszlo

The replay answer
Advertisement
Hi Laszlo!
We have found and discussed the answer already, but to more people can see it I write it.
When You have the results already, You can use the 'Advanced' page to see the XML source. There you can modify the code carefully. Change the section:
<saw:dataFormat xsi:type="saw:percent" minDigits="2" maxDigits="2" scale="2"/>
Change maxDigits to the number of decimal digits You wanted.
Although we found the answer on the course, I found later this page - also could help:
http://blog.trivadis.com/blogs/andreasnobbmann/archive/2008/07/15/quot-percent-of-quot-in-obiee-s-pivot-tables.aspx
Best regards,
Tamas

Go to See the other 2 answers

Decimal Places in Pivot table

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, When I create a pivot table with a measure and I choose "Show Data as ... percent of something (for example section) I get the result with 1 Decimal Place. How to modify it for 2 or more Decimal Places? Thanks LaszloHi Laszlo! We have found[More]

Mimic "show data as percent of row parent" in non-pivot table

Category:DefaultRelease time:2015-10-11Views:130

Is it possible to implement or mimic the 'percentage of parent row' functionality, foreseen for pivot tables in obiee 11g, for a 'normal' table? We use a rather fixed table, in which no drilling is allowed - conditions are applied by means of prompts[More]

Data format in pivot table calculated item

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I've got a pivot table with a dimension on rows and a dimension on columns and a measure. I have a "new calculated item" based on the dimension on the columns which does the following: ( ($2-$1) / ($1) ) *100 I want this calculated item[More]

Formatting metrics in a pivot table differently based on a unit of measure

Category:DefaultRelease time:-0001-11-30Views:130

I have a generic metrics table with columns for METRIC NAME, UNIT OF MEASURE, ACTUAL VALUE, BUDGETED VALUE, and PRIOR YEAR VALUE. Each metric has a unit of measure associated to it, and I need to be able to format these metrics differently in the sam[More]

Access Pivot Table truncates sums

Category:DefaultRelease time:-0001-11-30Views:130

I use Pivot Tables in Access 2007 a lot and discovered recently when trying to tie out the results that when the raw data has decimal values, as in a currency format, the sum function in the pivot table is truncating the results to a whole interger. [More]

Conditional formatting on total cells in pivot table

Category:DefaultRelease time:-0001-11-30Views:130

Hi, i have a pivot table with some values and percentages. The percentages are in red if less then 0. I have 1 row and 1 column of total values, but this cell aren't red if percentage is less then 0. Does anybody know a solution for my problem? Thank[More]

Division between two columns in pivot table in Answers

Category:DefaultRelease time:-0001-11-30Views:130

Hi all In answers if I have two columns in my pivot table say column A and Column B, how can I use a division of Column B by Column A to derive Column C. I am unable to do that using the "New Calculated column feature" or in the criteria section[More]

IF statement in Calculated Field for Share point, doesnt calculate sum in my Excel Pivot table.

Category:DefaultRelease time:2015-10-11Views:130

Hi Everyone I used this in SP calculated column field. =IF([Shift Sched]="1pm to 10pm","0",IF([Shift Sched]="2pm to 11pm","1",IF([Shift Sched]="3pm to 12am","2",IF([Shift Sched]="4pm to 1am&[More]

Can any one tell how to create pivot table

Category:DefaultRelease time:2015-10-11Views:130

Hi , Am trying to create a pivot tabel in the MDM Import Manager. Iam able to see the preview of the pivot table which i want to create. But when i try to click "OK" button, an error message getting displayed like... "The new table cannot b[More]

Can I 'explain' data in a pivot table?

Category:DefaultRelease time:2015-10-11Views:130

Hi All. I have a request that has baffled me. I need a way to use 'text' to describe the results of a report. If I were doing a simple report, this would be a non-issue. Here are my hurdles: I have a report that uses a Union via Set Operations (so I'[More]

Not able to see data in Pivot table

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a issue with pivot table i have a column which displays values 0 and 1 and another column called month when i am placing this month column as a section and values column as a measure i am not seeing any values means i can see the month as[More]

Hot
Hi, I am trying to grant java permission as sys to an Oracle schema 'RCA' as follows but am getting the error ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException: policy table update java.io.FilePermission, <<ALL [More]
Has anyone experienced an issue with the latest update to iTunes (11.2.0.115) for Windows where iTunes pegs out the processor at 97%, 98%, and holds there for maybe 15 minutes before dropping to 50%. During that time, the system is basically useless. [More]
Hi All, May I know how to integrate BOXI 3.0 reports with SAP portal 7.0/7.1? Best Regards, RiteshHi, Please find a thread to understand BOXI integration with SAP portal. Configure BO with SAP Portal BO integration kit for SAP is available at https:/ [More]
hello There, I have just got a secondhand 1.33MHz 15" powerbook G4. The last owner said battery was on its way out but it worked fine with a power adapter. I booted the powerbook up and it started fine and dandy, ran for a couple of minutes and then [More]
I been using Logic seen Logic AV 3.0 when it was emagic, I must say I love what Apple has done for it! But one thing I like to see done with Logic is, it's owe hardware like protools, I know apple can do this!! Like DSP cards and a Pro mixer if you a [More]
i'm coming across this situation almost daily, iTunes will refuse to close when i hit the close button or go File -> Exit. sometimes i will get a prompt that iTunes is scripting but usually it just doesn't respond to either methods of closing. obviou [More]
I opened my iTunes account a number of years ago and each time I need to reset my account password I have to get an email sent In the event I have an issue with my email address I want to answer the security questions but I am unable to remember what [More]
Hi Everyone, we are using ESS1.0 SP 7, MSS1.0 SP 7 in EP 7.0 SP 10 Now i want to upgrade SP 7 to SP 14 can any one tell me stepwise how to upgrade to SP 14. Thanks in Advance, vv.Hi the Procedure is like this. Deploy the following Packags through SDM [More]
I have a macbook pro OSX 10.5.8 and cannot seem to upgrade to Snow Leopard using my Snow Leopard disk. My MacBook Pro has an Intel chip. Why is this so complicated and how am I supposed to install Snow Leopard if I can't do it via disk??It may intere [More]
hi all, can you any one explain the difference between DB time, OLAP time, frontend time when execute the queryEach BEx quey form a SQL query which is called query execution plan. So, DB Time is the time taken to read the record from data base by the [More]