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]

Problems with dynamic data slices and BEx Analyzer

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

Hello experts, we use a data slice to lock released data. This data slice contains an exit-variable which selects all plan that are already released out of a ABAP dictionary table. The user can release data via planning function. He can start this fu[More]

CKF not showing correct results in BEx Analyzer

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

Dear Friends, I am getting different results when viewed from BEx Analyzer and Web Analyzer for the same query. BEx Analyzer shows incorrect results. The column that is showing different is a local formula (say Formula3) that is a result of dividing[More]

BEx Analyzer: How to optimize reporting over a hierarchy?

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

Hello there, using BEx Analyzer & Excel, we're reporting over a large hierarchy of cost centers, beginning at the top level and then looping over 166 different cost centers in that hierarchy. Looping works from within a macro, calling the SAPBEXSetFi[More]

Automated start of Excel BEx Analyzer via Web VBScript

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

Hi all, at first... all the versions: SAPGUI 6.40 Patch Level 19, BW 3.5 Addon Patch 9, BI 7.0 with NetWeaver 2004s, Excel 2002 SP3. I got the following working code to start Excel out of our Intranet, start the BEx Analyzer and connect to our BW: <h[More]

Save button at bex analyzer

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

Hi i am using ready input query on aggregation level. copy and delete functions are working fine i have actual and plan cube i restricted sales doc num i copied values from one sales doc to another sales doc values to plan cube , so its working fine[More]

Variable hierarchy display not changed (BEx analyzer)

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

Hi We have a BEx query, in which a drilldown characteristic is displayed as an hierarchy Hierarchy display is active Selected hierarchy: Name - constant Version - customer exit variable Customer exit calculates version from manual input variable. We[More]

Query Not Running Via BEX Analyzer Role Menu

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

Hi All, I have a problem when executing queries via the BEX Analyzer role menu. I can select a query from a role but, when I select the query to run, nothing happens. When I select the same query from the infoarea it runs without any problems. This b[More]

BEx Analyzer versus BEx Web Analyzer and BIA performance

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

Hi Experts, Recently I tested the performance of a few of our queries running off Infocubes with indexes loaded to the BIA and I noticed some differences in performance when using BEx Web Analyzer versus BEx Analyzer in Excel.  Seems that when using[More]

Hot
I have a 13" white macbook (my daughter's macbook). It looks like the hard drive crashed. She took it to Apple store they told her they can replace the hard drive (still under Apple care), but I am trying to get the data from the hard drive. I pulled [More]
Why is Dreamweaver so slow to open up the server-side view of a web site? Thought it was my slow web site or connection. After the script finally timed out claiming the server was taking too long, I tried Transmit. Guess what? It just POPPED open. Ma [More]
I am trying to use Droid X as hot spot to my laptop.  Not sure how to set the computer so that it will recognize the droid...Yeah that is the most important part....  Now if you have a plan for the Hotspot then all you should have yo do is start app [More]
Hi Guys I need help whether we can achieve this functionality or not. The client creates Asset PO with non valuated material. For each and every PO we create a new asset master data. And at the time of GR we give the serial number. Now the client wan [More]
Hello I have installed OEL Linux and I have to configure a tape which will be used to back files automatically during the night. I have one problem which is I do not know where to start.. My list of requirements is as below: Daily back-ups automatica [More]
I have been using PS 7 for quite a while and now have to move to CS4.  However, I cannot figure out what the comparable menu items are. So, is there a "table" out there somewhere that starts with maybe version 7 and has all the comparable comman [More]
Hi opening cs6 displays all toolbar which work ok. But main screen is blank and displays.  could not complete your request because it is not the right kind of document   What do I do. Any help would be appreciated thanksPlease read these (in particul [More]
Hi, There seems to various postings regarding this issue, but I have never come across one that could tell me how to do it. And that is, how, in a PL/SQL portlet, do I remove the 'Oracle Banner' from my customization page or how do I add my own, defa [More]
We have user accounts on our OS X Tiger Server where the user has installed a public key into their ~/.ssh/authorized_keys file. The problem: If I uncheck "access account" in Workgroup Manager for one of those users, they can still login to the [More]
I have developed a test rig monitoring system. Since there are a large number of transducers and thermocouples I have had to divide the monitoring system into two parts. An air system Front pannel, which is interactive,alloying me to start stop pause [More]