Sitemap

Amicuk Programming Answers

Key Figure Summation in DSO

2015-10-11   Views:2

Advertisement

Hi, I am loading data from Cube to DSO. In cube i have fields with 2 records below as example f1=1 f2=2 f3=3 f4=4 and key figure k1=1 f1=1 f2=2 f3=3 f4=4 and key figure k1=1 In DSO all these f1's fields are key fields as per requirement. And when i l

Hi,
I am loading data from Cube to DSO.
In cube i have fields with 2 records below as example
f1=1 f2=2 f3=3 f4=4 and key figure k1=1
f1=1 f2=2 f3=3 f4=4 and key figure k1=1
In DSO all these f1's fields are key fields as per requirement. And when i load now i get in DSO as
f1=1 f2=2 f3=3 f4=4 and key figure k1=2
I do not want k1=2 but i want k1=1 in DSO and not sure why this is getting summed up even though i have selected overwrite in Transfer rules.
I have checked mapping and cube data. All are fine.
I just want to avoid this and do not know what to do.
A routine or formula or something else?
Please help.

The replay answer
Advertisement
Hi,
Check your DSO Design
Keep f1 ,f2, f3, f4, are in KeyFileds of DSO  and Keep key figure k1 in DataFields of DSO.
Here I'm assuming that F1 to F4 are Charecteristics.And only K1 is Keyfigure. If this is the case then I hope it will work if you follw the above design.
Thanks
Reddy

Go to See the other 10 answers

Impact of Delta Records on Key Figure Summation in DSO

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

Hi experts, I have a key figure with aggregation type "summation" in a DSO. I would like to know the impact of delta records on the key figure. E.g. source DSO doc_id (key) | doc_pos | type | amount 4711 | 1 | A | 100 USD 4711 | 2 | B | 20 USD t[More]

Key Figure Summation in DSO

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

Hi, I am loading data from Cube to DSO. In cube i have fields with 2 records below as example f1=1 f2=2 f3=3 f4=4 and key figure k1=1 f1=1 f2=2 f3=3 f4=4 and key figure k1=1 In DSO all these f1's fields are key fields as per requirement. And when i l[More]

DSO - Key figure  summation

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

Hi Experts. I have a question on how BW is thinking when updating DSOs. If I mark the keyfigures in the DSO to summarize, what will then be the effect. If I compare to a SQL sentence I will sum the keyfigures for sure. But will i Group by all the oth[More]

Key figure summation for KF IN different cube of a MP

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

Hi,    I need to design a report on a Multiprovider. MP is based on two Cube Cube1 and Cube2.    Cube 1 has field item and key figure total quatity.  Cube 2 has field item and key figure  quatity1.    I need a report which will show                  [More]

Changing key figure values in DSO/Cube

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

Experts, I have a DSO and a Cube and the data has been already loaded in to a amount Key Figure. By default it is 2 decimal places. I want to change the decimals to 7. I cannot delete data from the cube or the DSO. Can you please suggest some ideas t[More]

Key Figure Summation in Result Row with Cumulation Ticked

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

Hi, I have a Bex question regarding the summation rows.  I need a Year To Date amount and a Period To Date amount in the report.  However, there is no Year To Date key figure available in the cube.  So in order to calculate YTD, I'm using the PTD key[More]

Key figure summation

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

Hi All I searched SDN forums and could not find a solution for the same. I have added a keyfigure as display attribute in 0costcenter masterdata. The same is available as display attribute in headcount cube (0papa_c02) via 0mast_cctr. Now at the repo[More]

Key Figure values based on characteristic Drill-downs

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

Hello All, I have Issue with my drilldown options in the report. The values of Sales qty need to change at particular drilldown. I have Sales Revenue and Sales QTY key figures in my DSO with  plant, factory, customer and Business type (Values A, B, C[More]

Key Figure's Result Summation and SUMGT

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

Goal: I need to capture the report’s  Results for KF1 and KF2 to use it in the same report for further calculations. However, the report should include into Results calculations only the records that have KF1 or KF2 with values greater than 0. Potent[More]

Hot
I'm trying to sync music and podcasts to my Nano and I get an error message (-50) saying it wont sync. Then I get another error message saying that the disk could not be read from or written to. I have the newest version of iTunes and the newest vers [More]
It started with my iTunes not wanting to update at all. I kept getting an error that read "cannot access %appdata%". Ok so I let that go, still had my music, podcasts, books, etc...I just didn't have an updated iTunes. It still worked so I was c [More]
I am unable to open Icloud on my PC with Windows 7 but have it on my Iphone & Ipad working OK Please helpThe menu selection only shows the other options if you already have a selection active; a selection made with one of the available tools like las [More]
How do I delete voice mail from my iphone 4s? I keep getting a message that my voicemail is 98% full.i realised i have this 200mb of messages this morning & tried deleting my messages but it started to hang half way and my phone gets very hot. thn i [More]
Getting error when I try to install an excel addin that I have published. Error message is  "Configuration system failed to initialize". The popup window has the title "visual studio tools for office solution installer" To publish the [More]
Hello, Setting up the Content Server I encounter this problem with the fulfillment server Status check-up: exception javax.servlet.ServletException: Servlet execution threw an exception root cause java.lang.Error: Problem reading key and certificate [More]
Hi all, I wonder if anyone can shed any light on this? I'm trying to spelling-check a long text document in ID CS4.  It's essentially a simple document -- all text, with some paragraph styles applied for formatting chapter headings, but nothing compl [More]
Hi all My Discoverer report takes about 5 minutes to run in the test environment. The same report (absolutely the same SQL in the custom folder in the admin edition and the same conditions and sort in the Desktop edition) takes at least 45 mins to ru [More]
<p>Hello, </p><p>I am trying to create a report with two commands (without link) Command1 would have data in any circumstance as it has the report information (e.g title etc.,) which is stored in database.  </p><p>Command2 da [More]
Hi All, Can you please let me know standard driver program for Scheduling Agreement (ME31L) Adobe Form MEDRUCK_SCHEDAGR. Thanks, SamratHi Samrat, The print program for Adobe Form MEDRUCK_SCHEDAGR. is SAPFM06P. Regards SandyRead other 2 answers [More]