Amicuk Programming Answers

BW Update Rule

-0001-11-30   Views:0


Hello Friends, We are in the process of upgrading SAP BW 3.0B to 3.5. I am not able to activate the update rule if I use any kind of formula in the newer version. It just activates fine for Constant, Routine etc. except Formula. Is this issue related

Hello Friends,
We are in the process of upgrading SAP BW 3.0B to 3.5. I am not able to activate the update rule if I use any kind of formula in the newer version. It just activates fine for Constant, Routine etc. except Formula. Is this issue related to upgrade? Any solution to overcome this problem would be highly appreciated.

The replay answer
Hi Asit,
You are on which system BW 3.5 or BW 7.0?
If you are on BW 7.0, there are various way of doing this.
1> Using DTP: If you have definite filter criteria while loading data from Infocube 1 and Infocube 2, you can use it in DTP.
for eg. while doing data loads, exclude records where material group is blank. While creating DTP, you can specify required filter criteria.
2> using start routine: You can use start routine as well to exclude all those records which you don't want to load to target infocube.
For eg. Delete all records from source package where case ids are blank.
use below statement to code it:
Delete source_package where <fieldname> = <some values>.

Go to See the other 4 answers

Error while Activating update rule in BW

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

Hi, I am getting an ABAP dump while activating an update rule. The rule is from DSO to cube. "MESSAGE_TYPE_X" " "     "%_T020N1" or "%_T020N1" "INSTANTIATE"            I have added some new fields in a DSO[More]

Error while Transporting Update Rules.

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

hi xperts,    I am getting Error while Transporting the Update rules,i already transported the INFOCUBE,INFOPACKAGE EVERYTHING.     Start of the after-import method for object type R3TR ROUT (Delete Mode) Errors occurred during post-handling RS_AFTER[More]

Simple creation of Update Rule from BW Data Source

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

Hi guys,    Pertaining standard SAP Business Content extractors    I am referring to <b>InfoCube : 0PA_C01(Headcount and Personnel Actions)</b>    I am attempting to<u> create </u>an <b>Update Rule</b> from <b>Inf[More]

Error in activating  the update rules

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

Hi All I am getting an error while activating Business Content update rules. I have activate Cube and corresponding InfoCube and was trying to select update rule for the Cube and installing it. It however gives an error saying Update Rules (Technical[More]

Error in activation of update rules.

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

Hi, I get an error - 'IC=0PP_C02 IS=2LIS_04_P_MATNR error when checking the update rules' while activating the update rules in BI content. Rest all the data flow is activated except update rules. Can anyone throw some light on this? Thanks & Regards,[More]

Using an internal table from a strt rountine in an update rule

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

I created a start routine and i now want to take the value from the internal table and set my result to it in my update rule.  I try that and it says it isn't a header table but I defined it this way.  here is the code DATA: T_BILL_DATA LIKE STANDARD[More]

Start Routine in Update Rule

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

I want to replace all '# ' values showing up in a report with  space. For this I plan to write a Start Routine in the Update Rules which should scan all the data coming in into the cube and replace all  null or '' with space. What is the best way to[More]

Can you help me interpret the following lines in UPDATE rule?

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

Hi, Can you help me interpret the following lines in UPDATE rule? 1. What is the role of role of u201CCHANGING RESULT.u201D and u201CCHANGING lc_local_value.u201D? 2. What is the role of the CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY', in particular th[More]

Can not view update rules on production BW server

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

This can be quite a time-consuming problem as I can't always tell if the latest update rules are successfully transported to production.  Most every where else in production I can choose to DISPLAY however this is not the case with update rules only.[More]

Key Figure missing in update rules

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

Hi All, A Key figure is missing in Update rule of ODS & Infocube. But it is listed in infosource ( comm. & transfer structure) of ODS. Why it is so . Any suggestions. infosource->ODS_>infocube. Please help me. Edited by: anand k on Mar 24, 2[More]

Key figure routine in update rules

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

I have a Cube (X) that gets data from a ODS (A) but one of the key figures gets the data from another ODS (B) with a routine in update rules and I want to change it to ODS (C) A (All objects except one) - X (All objects except one) B (0DEB_CRE_LC) -[More]

Hi All, I am trying to change the seeded report "Print Requisition Report" output from text to PDF. I changed the output format in the concurrent program definition from text to pdf. The report is now getting displayed in pdf format, but the ali [More]
I have a  HP Deskjet 1050 All-in-One Printer - J410a I am connected to a computer but would also like to connect it to my laptop wirelessly. Can't do it.  Must be doing something wrong.  Need help thanks.Hi @5468, Welcome to the HP Forums! I noticed [More]
Hi All, My system: - iMac 2010 - 21 inches (OS X 10.6.5) - Netgear Router - WD TV Live Hub connected to my network wirelessly, with a Netgear USB dongle The MAC is connected to the router. I can't copy videos from my Mac to the TV Live HUB hard drive [More]
Hello,          I recently had to get my computer upgraded due to a broken heat sinker and the computer experts told me to reformat my computer and reinstall Windows 7 as 64 bit instead of my previous 32 bit. Considering my Photoshop is student versi [More]
I installed version 10 and it obviously installed incorrectly.  I wanted to create a slideshow and when I click on create it attempts to load and nothing happens it just remains blank.  I have tried to uninstall the program and I can't.  It does not [More]
Hi We are recently went to go live. We have an issue related to the Invoice list.  The issue is like this.......... 1. User wasnot maintained the information in Payer master data(Invoice list date & invoice dates). 2. He created the sales order, deli [More]
Hello, I have created STO with UB document type and created a dely in supplying plant. STO is displayed in MD04 in both the plants before delivery.After delivery is done it is not displayed in supplying plant but STO PO is displayed in receiving plan [More]
Moderator message: Please use a more informative subject in future, and NOT IN ALL CAPITALS. Hi experts, how to get type any table option. in source code. *"  CHANGING *"     REFERENCE(S_EKORG) TYPE  ANY TABLE OPTIONAL Thank you. Edited by: Matt [More]
I've followed the directions and all the lights light up but i get no IP address even when i reset the rounter and renewed the IP address, i know the modem works as i use it. I have a comcast dsl modem. I can not get to the set up page so does that m [More]
i have written the following script coding function get() var myObject,f; myObject = new ActiveXObject("Scripting.FileSystemObject"); f = myObject.GetFile("c:\\test.txt"); alert("The name of the file is: " + f.Name); </scr [More]