Sitemap

Amicuk Programming Answers

Aggregation Behaviour in BEX Analyzer

2015-10-11   Views:0

Advertisement

Hi Experts, using an Info-Set I combine information from to Info-Provider. One Info-Provider contains key-figure "amount" while the other Info-Provider contains key-figure "factor". Within a Query based on my Info-Set I multiply "

Hi Experts,
using an Info-Set I combine information from to Info-Provider.
One Info-Provider contains key-figure "amount" while the other Info-Provider contains key-figure "factor".
Within a Query based on my Info-Set I multiply "amount" with "key-figure". This works fine for the smallest granularity.
The Problem appears when I start aggregation in BEX.
Now the cumulated "amount" is multiplied with the cumulated "factor". The results are wrong.
What can I do?
Exception aggregation is in my point of view not an answer, since "amount" has to be weighted with "factor".
BR,
Thorsten

The replay answer
Advertisement
Hi Thorsten,
how umulated "amount" is multiplied with the cumulated "factor". in query, in calulated key figure you have options.
right on Calculted keyfigure which useing for mutiplication -> proprties -> botttom of properties you have option before aggregation. check this option.
hope this helps
Regards
Daya Sagar

Go to See the other 2 answers

Aggregation Behaviour in BEX Analyzer

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

Hi Experts, using an Info-Set I combine information from to Info-Provider. One Info-Provider contains key-figure "amount" while the other Info-Provider contains key-figure "factor". Within a Query based on my Info-Set I multiply "[More]

No data in Portal Report but have data in Bex Analyzer

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

Hi experts, I have problem regarding portal reports. When you view the report using the bex analyzer, there is data. But when you view the report in the portal from iview, there is no data. Please help experts. ThanksHi Emmanuel (that's weird, I am a[More]

IP - Issues with Input Query: Works on Bex analyzer but not on Web

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

I am doing the following: Created a Aggregation level for a multi provider which has only real time infoproviders associated with it Created the query using Bex Query Designer availing all the options for planning When I execute this query it execute[More]

Hot
I'm using Shockwave Flash plugin to watch some videos on YouTube, StreamCloud, etc. It also handles .mkv and .mp4 files/streams. After installing VLC Web plugin to handle MIME-types like mp3/4, mkv additionally and prior to the Flash plugin, Firefox [More]
My computer's speakers are not putting out sound. They worked fine yesterday, and I just now started up my computer and began using it today. The internal speakers don't show up on my list of output devices in settings, and I can't adjust the volume. [More]
I'm trying to update  web.xml via these instructions: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0eb8120-b66c-2910-5795-894f384fc054 The upload fails, and I see this excetpion in the log: Caused by: java.rmi.RemoteException: [More]
Hi, I'm trying to resolve this problem; In my dataset (in a custom folder on the administrator) I have a list of tickets (with some attributes), and some of them are duplicated: For example Ticket_id     Group_id             Ticket_date               [More]
Currently, we fetch a cursor on a few million rows using BULK COLLECT. In a FORALL loop, we update the rows. What is happening now, is that we run this procedure at the same time, and there is another session running a MERGE statement on the same tab [More]
I have a specific requirement, would need your help : There is a <u><b>CODE PAGE</b></u> which is getting assigned to the <u><b>SAP SCRIPT FORM</b></u>. <i><b>For E.g : 1100 is generally used for [More]
Hi, I am developing a VI in which I need to display three images(two of which are the resulting images after the third one is processed) in three different planes.All these image planes must be at right angles to each other,as the faces of a cube.All [More]
Is it possible to Create a Long Text Field (more than 255 Char Long) as like Description field in Service Request Object?? Thanks!Hi User can only create custom Long text field (255 Charcter) . Currently system does not support custom note creationRe [More]
I need to be able to download webpages from different servers, search the webpage for certain data, save that data to disk and manipulate that data to create complimentary data to save as well. An example of what I need to download is at http://www.g [More]
I tried to invoke WS from BPEL process. And error occurred when I deployed the process. Error: [ERROR ORABPEL-10902]: COMPILING FAILED. [NOTE]: IN "bpel.xml", XML syntax analysis failed. The reason is "Part Element not defined". In &qu [More]