Sitemap

Amicuk Programming Answers

Decimal Points in Report Output

2015-10-11   Views:0

Advertisement

Dear Experts, We have a keyfigure 0GR_Qty in the cube 0pur_c01. For a Purchase order the 0GR_Qty in the cube 0pur_c01 is 9.12 MT. We created a report on this cube and executed the report for this PO, but in the output the 0GR_Qty is showing as 9.00 M

Dear Experts,
We have a keyfigure 0GR_Qty in the cube 0pur_c01.
For a Purchase order the 0GR_Qty in the cube 0pur_c01 is 9.12 MT.
We created a report on this cube and executed the report for this PO, but in the output the 0GR_Qty is showing as 9.00 MT.
It is not showing the decimals. I tried with removing the decimals and also increasing the decimal points to 4 or 5 etc. But also it is
not displaying the decimal points.What may be the reason ? Please specify. Not only for this PO for all other po's also it is showing
like this.
Regards,
Bhadri M.

The replay answer
Advertisement
Hi All,
Thanks for the reply.
After changing the properties of keyfigure also the decimal places are not coming in the query output. In listcube i checked for 0gr_qty, it is showing as 9.12 and the base unit is MT.
In CUNI how to maintain the number of decimal places for the unit MT. I am unable to find this unit here.
Regards,
Bhadri M.

Go to See the other 6 answers

Decimal notation in report output

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

Hi Experts, My requirement is want to display values in report with out decimal notations( , .). Eg: 2,008.00 Output should be 2008 I know one solution , by maintaining user profiles we can achieve this .But this solution is user specific. I need a s[More]

Decimal Points in Report Output

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

Dear Experts, We have a keyfigure 0GR_Qty in the cube 0pur_c01. For a Purchase order the 0GR_Qty in the cube 0pur_c01 is 9.12 MT. We created a report on this cube and executed the report for this PO, but in the output the 0GR_Qty is showing as 9.00 M[More]

Decimal upto 3 places in ALV report output

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

Hi Experts My requirement is that User wants to have 3 decimal places in report output.I have used type P decimal 3,also have used field catalog Decimals_o = '3' .In the report output Lets say Previously it was 123 now after the changes its coming 12[More]

Key figure, number of decimal places are not showing in report output

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

Dear experts, At cube level PO qty value is getting 0.010 where as in bex report output of PO qty showing as 0. I have chosen decimal places as 0.000 in key figure additional properties tab. In query designer also I have chosen no of decimal places a[More]

Report Output for Currency Field--EKBE-WRBTR

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

Hello ABAP Experts Since the Issue is related with Related Report output. Thought ABAP General Forum would be right place to post. If not Suggest an appropriate forum for the same. I shall post them in Correct Forum. Currently the report display Curr[More]

BI Publisher - PO_DISPATCH Error generating report output

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

Hi everyone, Sorry for my bad english... having said that... I need to modify the Purchase Order print. First, I wanted to see the standard version to get an idea of how much different it was. Well, I don't know because it doesn't work. Error: Error[More]

Reg: ALV report -  output download

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

Hi Friends, I am having one issue reg download of  ALV (Grid display) report output. we are having vendor number at 1st colomn. It's displaying correctly in output. (eg:0000100069). But, when I download the output into a excel file, last digit of the[More]

Discoverer report - Output from Discoverer plus is not the same as Discoverer desktop

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

As a part of Upgrade project we are migrating the discoverer reports from 11i (11.5.10.2) to R12 (12.1.3) .After migrating to R12, for a custom discoverer report the output given by discoverer desktop is correct (24 rows for a scenario). But the repo[More]

Change order of key figure is not working in Web report output (using WAD)

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

Hi, We are using BI 7.0, release 701 and level 008. We are facing problem in WAD (web report output). When ever we do 'Select filter' for key figures and 'change the order' of key figures, it does not get reflected in new order. Though drag and drop[More]

How To Restrict Number Of Rows For Multiple Group In Report Output

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

Hi , I have a requirement to restrict number of rows in report output.I have three different group , if i use same no of rows to restrict then output is as expected but if i want Deduction group should have 7 rows , earning should have 5 rows and Tax[More]

Intermittent Blank Rows coming in BI Publisher Report output

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

Hi, We are working on a BI Publisher report output. Issue The report sometimes creates a blank row along with the headings of the report columns. Table has multiple records and between 2 records we have a data being displayed which is optional. When[More]

Hot
I've been running an internal disk drive on ReFS under Windows 8.1 since late last year, and have had nothing but perfect operation from it. I know that originally, when Win 8 came out, it was not possible to format an external USB drive to ReFS.  It [More]
I'm trying to understand how the copy-on-write and Btrfs snapshot works. Following simple test: <pre> # cd / # touch testfile # ls --full-time testfile -rw-r--r-- 1 root root 0 2012-10-15 12:04:43.629620401 +0200 testfile Test 1: # btrfs subvol snap [More]
hello i have NC6400 HSTNN-C18C and i have problem with graphic drivers.i have windows 7 proffesional i found some .but in install has failed installation .i have installed game Farming simulator 15 but i still must install latest graphic drivers.can [More]
Hi guys i am used in creating binary trees ,tell me how do we create non binary trees in java.public class Node {   private final Object payload;   private final Set<Node> children;   public Node(Object payload) {     this.payload = payload;     chi [More]
Hi experts , I'm studying SD & MM functional, I need to know about real time SD & MM Workflow scenarios, how it works, how it is configured, administrated etc. If u have any screen shot Pdf on SD or MM workflow's please send me the same to my e-ma [More]
I rencently downloaded sjsc and now I'm tyring to deploy a sjsc / jsf project to weblogic 8.1 sp3, and keep getting this error: ======================================== Description: An unhandled exception occurred during the execution of the web appl [More]
Dear Colleague, We are trying to have a PoC demonstrating BW planning function and Planning sequence in SAP Business Objects Design Studio. 1. In the process, we have built our own Planning function and Planning sequences in our BW system and they ar [More]
Hi Members, I have designed a PLD In which there are fields to display discount percentage and discount amount at the report footer. I should display the discount percentage and discount amt if the item details has uniform discount given. Say for e.g [More]
I'm using a Pentium 4 PC and was wondering how do you publish a podcast via this PC rather than having to get a Mac? Also since I use Cubase SX 2, should that help me in creating the podcast? Pentium 4   Windows XP Pro  Hello: Not sure I completely u [More]
Hi, I have query like this: Select Main.X_ID, NVL(Option1.Y_ID, Option2.Y_ID), Main.Z_ID from TableMain Main left join (Select X_ID, Y_ID from TableOption where type_cd = 'Type1') Option1 on Main.X_ID = Option1.X_ID left join (Select X_ID, Y_ID from [More]