 |
 |
|
|
| |
| |
| |
|
|
| Articles about Persistent |
| SAP BI Persistent Staging Area | | 2008-08-02 03:44:43 | | Purpose The Persistent Staging Area (PSA) is the inbound storage area for data from the source systems in the BI system. The requested data is saved, unchanged from the source system. Request data is stored in the transfer structure format in transparent, relational database tables of the BI system in which the request data is stored in the format of the DataSource. The data format remains unchanged, meaning that no summarization or transformations take place, as is the case with InfoCubes. When loading flat files, the data does not remain completely unchanged, since it is adjusted by conversion routines if necessary (for example, the date format 31.21.1999 is converted to 19991231 in order to ensure uniformity of data). The possible coupling of the load process from the further processing in BI contributes to an improved load performance. The operative system is not debited if data errors first appear with further processing. The PSA delivers the backup status for the ODS layer... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
| | DB Storage Parameters BI Persistent Staging Area | | 2008-08-02 03:44:18 | | Use You can maintain database storage parameters for PSA tables, master data tables, InfoCube fact- and dimension tables, and DataStore object tables. Use this setting to determine how the system handles the table when it creates it in the database: · Use Data Type to set in which physical database area (tablespace) the system is to create the table. Each data type (master data, transaction data, organization- and Customizing data, customer data) has its own physical database area, in which all tables assigned to this data type are stored. If selected correctly, your table is automatically assigned to the correct area when it is created in the database. We recommend you use separate tablespaces for very large tables. You can find information about creating a new data type in SAP Note 0046272 (Introduce new data type in technical settings). · Via Size Category, you can set the amount of space the table is thought to need in the database. Five categories are a... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
| | Deleting Requests from the PSA BI Persistent Staging Area | | 2008-08-02 03:43:50 | | Use With this function you delete requests from the PSA. This reduces the volume of data in the PSA. Applications are, for example, deleting incorrect requests or deleting delta requests that were updated successfully in an InfoProvider and for which no further deltas should be loaded. Prerequisites You checked that the PSA data that you want to delete is no longer needed. Procedure Including the deletion of requests from the PSA in process chains You are in the plan view of the process chain in which you want to insert the process variant. ... 1. To insert a process variant for deleting requests from the PSA in the process chain, select process type Deletion of Requests from the PSA from process category Further BI Processes by double-clicking. 2. In the next dialog box, enter a name for the process variant and choose Create. 3. In the next screen, enter a description for the process variant and choose Continue. The maintenance screen... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
|
|
|
| Previous Technology of the PSA BI Persistent Staging Area | | 2008-08-02 03:43:06 | | The PSA is the entry layer for data in BI. The data is updated to PSA tables that were generated for active DataSources during the load process. The PSA is managed with a DataSource. The previous technology of the PSA was oriented to the transfer structure. The PSA table is generated for an active transfer structure in this case. The PSA as a standalone application is managed in an object tree of the Administrator Workbench. You can still use this technology when your data model is based on the previously available objects and rules (DataSource 3.x, transfer rule 3.x, update rule 3.x). However, we recommend that you use the concepts for DataSources and transformations available after SAP NetWeaver 2004s, which includes using the new technology of the PSA.... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
| | Checking and Changing Data BI Persistent Staging Area | | 2008-08-02 03:42:28 | | Use The PSA offers you the option of checking and changing data before you update it further from the PSA table in the communication structure and in the current data target. You can check and change data records to · Remove update errors. If lower case letters or characters that are not permitted have been used in fields, you can remove this error in the PSA. · Validate data. For example, if, when matching data, it was discovered that a customer should have been given free delivery for particular products, but the delivery had in fact been billed, then you can change the data record accordingly in the PSA. Prerequisites You have determined the PSA transfer method in transfer rule maintenance for an InfoSource, and have loaded data into the PSA. Procedure You have two options for checking and changing the data: ... 1. You can edit the data directly. ... a. In the PSA tree in the Administrator Workbench,... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
| | Checking and Changing Data Using PSA-APIs BI Persistent Staging Area | | 2008-08-02 03:41:46 | | Use To perform complex checks on data records, or to carry out specific changes to data records regularly, you can use delivered function modules (PSA-APIs) to program against a PSA table. If you want to execute data validation with program support, select Tools ® ABAP Workbench ® Development ® ABAP Editor and create a program. If you use transfer routines or update routines it may be necessary to read data in the PSA table afterwards. Employee bonuses are loaded into an InfoCube and sales figures for employees are loaded into a PSA table. If an employee’s bonus is to be calculated in a routine in the transformation, in accordance with his/her sales, the sales must be read from the PSA table. Procedure ... 1. Call up the function module RSSM_API_REQUEST_GET to get a list of requests with request ID for a particular InfoSource of a particular type. You have the option of restricting request output using a time restriction and/or the transfer method. You ... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
|
|
|
| Versioning BI Persistent Staging Area | | 2008-08-02 03:40:55 | | Use If you make an incompatible change to the transfer structure (for example, length changes or the deletion of fields), a version is assigned to the PSA table. Features When the system detects an incompatible change to the transfer structure, a new version of the PSA, meaning a new PSA table, is created. Data is written to the new table when the next request is updated. The original table remains unchanged and is given a version. You can continue to use all of the PSA functions for each request that was written to the old table. Data is read from a PSA table in the appropriate format. · If the request was written to the PSA table before the transfer structure was changed, the system uses the format that the transfer structure had before the change. · If the request was been written to the PSA table after the transfer structure was changed, the system uses the format that the transfer structure has after the change. If you program against function module R... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
| | Reading the PSA and Updating a Data Target BI Persistent Staging Area | | 2008-08-02 03:40:32 | | Use You can use this process to further update data from the PSA. This takes place after all data packages arrived in the PSA and were successfully updated there. Note that it is not possible to create more than one process of type Read PSA and Update Data Target for one request or InfoPackage at any one time. You cannot simultaneously update into more than one data target. Updating into more than one data target can currently only occur sequentially. This process replaces the indicator Subsequently Update into Data Targets on the Processing tab page in the Scheduler. When using an InfoPackage in a process chain, this indicator is grayed out in the Scheduler and the Read PSA and Update Data Target process is controlled by process chain maintenance. Any settings previously made in the InfoPackage are then ignored. Procedure ... 1. In the SAP BW Menu, choose Administration ® Process Chains. In the Administrator Workbench, choose Process Chain Maintenance f... | | By: FreeSAP Business Warehouse(BW) Books,Faqs,Material | | |
| | dollar slips amid persistent US bank worries | | 2008-07-21 12:43:00 | | 1. Dollar falls on continued worries about U.S. financials2. Sentiment toward dollar remains cautious3. Investors watching U.S. earnings, oil pricesJuly 21 - The dollar slipped on Monday, losing some of its recent momentum, after better-than-expected earnings from Bank of America failed to convince investors that the worst for the U.S. financial sector is over.The greenback had earlier gained against the yen and pared losses against the euro after Bank of America's second-quarter earnings beat ... | | By: Forex Trading House (USA) | | |
| | | | Persistent Crying-Baby Care | | 2008-04-26 00:03:00 | | Some young babies have prolonged bouts of crying, which typically occur in the late afternoon and evening, and can last any where between two and four hours. Babies often begin this pattern of persistent crying at about three weeks of age, and will usually have grown out of it by about three months. This pattern of crying has become known as colic, because as the baby becomes increasingly upset and difficult to soothe, he may often pull his legs up and arch his back as if experiencing abdominal pain. In fact, it's probably misleading to give it any special name, because there doesn't seem to be any known cause for this pattern. Getting Through It A baby who is persistently fretful may cry readily at other times, not just in the evening. However, the evening pattern of crying can be a particular strain for parents, especially if one or both of you has been working during the day. It may be that your baby senses and resets to your tiredness at this time. Although this crying pattern may ... | | By: Baby Health Care | | |
| | | Stock picks from a persistent bull | | 2007-12-11 10:55:00 | | Markets may be in a turmoil, but hedge fund veteran Leon Cooperman still thinks equities are a buy, and shares some of his best picks.By Katie Benner, writer-reporterCooperman believes the market has already priced in the worst economic data.More from FortuneDrawn-out Citi search nears endNEW YORK (Fortune) -- In the days leading up to the August credit crunch, stock prices fell and prognosticators said the bull market had run its course. But Leon Cooperman wrote in an article for Fortune: "I view this market drop as a long overdue correction rather than the end of the bull market."Several months have passed, along with rounds of bank write-downs, broken M&A deals and haywire stock prices, but the founder and chairman of Omega Advisors, a hedge fund with $6 billion in assets, still believes equities should move higher. In a follow-up interview, he points out that the S&P has gained more than 4% since his story and gives his four reasons to still like equities, including Alcoa (... | | By: How to be Rich, Happy and Free from Scams | | |
|
|
| |
 |
|
| |
| |
|
 |
