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 experts, In MDM catalog, I have a product with 'Price Information' and with 'Contract price'. I create a shopping cart with the 'Price Information'. Then, I create another shopping cart using the anterior througth the functionality 'Old Purchase o [More]
Dear all, I setup two nodes RAC in HP Alpha OpenVMS 8.2 , one node is CAPL21(instance number=1) and another is CAPL22(instance number=2) . when normally run about five days. the second instance CAPL22 terminated abnormally, I check the alert [More]
I use the export for web feature a lot.  I find that I have to bounce back and forth between Quicktime 7 and X because sometime this feature will work and sometimes it doesn't.  There's no consistent reason I can figure out why the applications will [More]
Gurus... I am working on this single table which needs to be exported from prod and import into test. As I understand I need to follow below steps: 1. Test - export table abc dump as backup 2. Prod - Export single table abc 3. Test - Drop table abc c [More]
Aodobe thinks the issue is that my DELL 620 i5 with 6GB RAM 2 TB drive 500GB scratch disk and Windows 7 64bit is the problem. However, since the system is just over a yr old I do not want toreplace it just to make the CC products run.So does anyone h [More]
Hello all,   I have a Compac cq62 with the AMD p320 athlon cpu in it and am looking to upgrade it.  My motheboard is an HP 1444 and would like to know what cpu's it can use. thank you. JeridHi, Please write your notebook product number (p/n), which s [More]
we have an assignment for class to find 3 examples of interactive pdf documents on the web everytime i put the info in it comes up with how to do it or create it i just need 3 links to show examples in class please somebody tell me how to search for [More]
Hi All, I have a web service that's defined like this: <mx:Webservice wsdl=" http://username:[email protected]/webservices/myservice.asmx?WSDL" /> username and password are replace with the username and password used by IIS's basic authent [More]
In the past I thought I put the soundtrack as a AIF file in Soundtrack Pro and then copied and pasted it into a photoshop window, but that doesn't seem to work now.Roger Longley wrote: In the past I thought I put the soundtrack as a AIF file in Sound [More]
Hi all, First of all, I am from Holland, I'll try my best not to write in riddles.... I have two 30 minutes DV tapes I would like to edit and than show to my friends in Holland AND the States. How do I start ?? My idea is to import the footage of eac [More]