Save info   Get password
Home Submit your blog Edit Account Rules RSS-Archive Contact
Show All




Web Catalog F305 C905 webbutveckling Article Directory




The Three Layers of SAP BW
2008-08-09 02:15:08
SAP BW has three layers: Business Explorer: As the top layer in the SAP BW architecture, the Business Explorer (BEx) serves as the reporting environment (presentation and analysis) for end users. It consists of the BEx Analyzer, BEx Browser, BEx Web, and BEx Map for analysis and reporting activities. Business Information Warehouse Server: The SAP BW server, as the middle layer, has two primary ro
Read more: Three , Layers

SAP Data Warehouse
2008-08-09 02:14:46
We have large amounts of historical sales data stored on our legacy system (i.e. multiple files with 1 million+ records). Today the users use custom written programs and the Focus query tool to generate sales'ish type of reports. We are wanting that existing legacy system to go away and need to find a home for the data and the functionality to access and report on that data. What options does SAP
Read more: Warehouse

SAP Business Information Warehouse
2008-08-09 02:14:23
Ever heard about apples and oranges. SAP/R3 is an OLTP system where as BIWis an OLAP system. LIS reports can not provide the functionality providedby BIW. -----Reply Message-----Subject: Business Information Warehouse Hello, The following information is for you to get more clarity on the subject:SAP R/3 LIS (Logistic Information System) consist of infostructures (whichare representation of reporti


Use of manual security profiles with SAP BW
2008-08-09 02:04:30
Our company is currently on version 3.1H and will be moving to 4.6B latesummer 2000. Currently all of our R/3 security profiles were createdmanual ly. We are also in the stage of developing and going live with theadd-on system of Business Warehouse (BW). For consistency, we have wishto use manual profiles within the BW system and later convert all of ourmanual security profiles (R/3 and BW) to prof


What Is SPRO In BW Project?
2008-08-09 02:02:37
1) What is spro?2) How to use in bw project?3) What is difference between idoc and psa in transfer methods? 1. SPRO is the transaction code for Implementation Guide, where you can do configuration settings.* Type spro in the transaction box and you will get a screen customizing : Execute Project .* Click on the SAP Reference IMG button. you will come to Display IMG Screen.* The following path will


Main advantages of BW 3.0 over 2.1C
2008-08-09 02:02:15
Here's a brief list, without detailed explanations :- - XML support for reading and writing metadata and data.- Web application designer: graphically design and publish web reports and web applications.- Open Hub Service for distributing data to other tables/systems on a schedule. It supports selection, projection, and aggregation. Integrated into the BW monitor.- Process Chains and graphical sche


Pros and Cons of Web against BEX
2008-08-09 02:01:55
Web reporting is faster then Excel, there is less overhead in executing Web reporting as opposed to Excel. (Whitepaper on SAP about this.) There is not anymore work in formatting or creation of templates then in comparison to workbooks. Query creation is the same as in BEX, so there is no new knowledge there. Yes, knowledge of HTML is needed, but if you use the standard CSS templates, you really
Read more: against

API Functions Available In BEX
2008-08-09 02:01:31
API functions available in BEX 3.x: 1. Function SAPBEXinitConnection(Optional newConnectionObj As Object) As BooleanSet up a connection to BW Server 2. Function SAPBEXgetConnection(Optional what As Integer) As VariantGet the existing connection object if already connected to BW server by help of BEX 3. Sub SAPBEXattachGIS(Optional refreshOnly As Boolean) Attach GIS-MAP (same as clicking the BEX-To
Read more: Functions

Huge Performance Problems on SAP BW 3.10.
2008-08-09 02:01:05
We have huge performance problems on SAP BW 3.10. (Oracle 9.2, AIX). Our users don't get the results of theirs queries, and they often have to log-off from sap when they use the bex analyzer . I have read the differents topics regarding this problem , and read the differents SAP notes. *The database statistics are refreshed every moring , after the data loads. (statistic for the fact table is alw
Read more: Performance

How to build an extractor?
2008-08-09 02:00:35
Using SAP BW 2.1C and soon 3.0A we have to extract data from R/3 FI.Standard extractor can´t be used, since data need to be enhanced and go throug various routines before data contains all information needed in BW. Delta upload mechanism is needed.Where can information on- building a new extractor (including delta mechanism)- enhancing a standard extractor be found? Technically, programming a fun


COPA Extraction Steps
2008-08-09 02:00:13
The below are the command steps and explanation. COPA Extraction -steps R/3 System1. KEB02. Select Datasource 1_CO_PA_CCA3. Select Field Name for Partitioning (Eg, Ccode)4. Initialise5. Select characteristics & Value Fields & Key Figures6. Select Development Class/Local Object7. Workbench Request8. Edit your Data Source to Select/Hide Fields9. Extract Checker at RSA3 & Extract BW1. Rep


ODS infosource not showing up
2008-08-09 01:59:47
To display export infosources under the Infosource hierarchy you need to do the following : 1. Right click the tree at the highest level (Infosources node) and then choose Insert Lost Nodes. 2. Also make sure that under Settings under the menu options you have selected the option to display generated objects for ODS . By default the setting is set to hide objects. And finally refresh your tree


The query could not be saved due to a problem in transport
2008-08-09 01:59:27
After creating a query in BEX, you try and save the query, it gives you the following popup message: "The query could not be saved due to a problem in transport ". Steps to correct the problem: 1. Within Adminstrator Workbench click on the Transport Connection tab in the Navigation Window on the left hand side. 2. Select the Request BEx button on the toolbar. 3. Create a transport. 4. T


Query View Workbook
2008-08-09 01:59:08
You formatted a query view ( By changing Fonts/column width etc ) and saved as workbook in your favorites in the Browser. When you execute the workbook thru the browser you get the format that has been saved. However, you loose the format when you click the Refresh Button. How to set permanent settings so that formatting remains same as has been designed in the workbook? You can do this :- In Exc
Read more: Query , Workbook

Stop a scheduled infopacket
2008-08-09 01:58:46
I have tried using SM50 to stop a process that has been running forquite sometime. How do I kill a scheduled infopacket. Thanks, -----Reply Message-----Subject: RE: Stop a scheduled infopacket Hello select the Process and press F9. Or can kill the same from the OS levelusing the UNIX command kill -9 . Happy going.. -----Reply Message-----Subject: RE: Stop a scheduled infopacket Kill the job on t


BEX Query Authorizations
2008-08-09 01:58:28
We are have authorization issues with Querries. We have created a genericRole that has some Standard Query 's for our Company attached to this Role.We give access to this role to our user community. The problem we arehaving is that the users can Execute the querries and what they are supposeto do is only Save the Workbook to there favorites. We are running acrossa problem because some of the


SAP Console
2008-08-09 01:58:03
Subject: SAPConsole Good Morning to all Can I use the standard SAPConsole for Inventory Management relatedtransactions also. Examble: Movement 103 /105 etc. With Best Regards -----Reply Message-----Subject: RE: SAPConsole Can you please explain me, What is a SAP Consule? -----Reply Message-----Subject: RE: SAPConsole Dear: SapConsole is a standard SAP tool which was offered as of 46B (but isbackw


Delete unwanted Objects in QA system
2008-08-09 01:57:30
I have deleted unwanted Update rules and InfoSources (that have already been transported to QA system) in my DEV system. How do I get them out of my QA system? I cannot find the deletions in any transports that I have created. Although they could be buried somewhere. Any help would be appreciated. I had the same problem with you. And I have been told there is a way to delete the unwanted objects.


LO Cockpit Step By Step
2008-08-09 01:57:06
Here is LO Cockpit Step By Step LO EXTRACTION - Go to Transaction LBWE (LO Customizing Cockpit) 1). Select Logistics Application SD Sales BW Extract Structures 2). Select the desired Extract Structure and deactivate it first. 3). Give the Transport Request number and continue 4). Click on `Maintenance' to maintain such Extract Structure Select the fields of your choice and continu


Differences Among Query, Workbook and View
2008-08-09 01:56:40
Many people are confused by the differences among: Query , Workbook , and View. Here are my thoughts on the subject: A query definition is saved on the server. Never anywhere else. Although people say a workbook contains a query (or several queries); it does not. It contains a reference to a query. The workbook can be saved on the server; or anywhere else that you might save an Excel workbook. Wha


Customer Exit Variable In Bex
2008-08-09 01:56:11
The customer exit works at: 1. Extraction side After enhancing datasource in RSA6 we need to populate those enhanced fields in that case we have to create a project in cmod transaction and select the Enhancement assignment RSAP0001 and select the appropriate FM and need to write the select statement in the appropriate include. EXIT_SAPLRSAP_001 - Transaction data EXIT_SAPLRSAP_002 - Master data EX
Read more: Customer , Variable

PERI5 Conversion Routine BI InfoObject
2008-08-22 08:57:31
Use The PERI5 conversion serves to convert a five-figure calendar quarter in an external format (Q.YYYY, for example) into the internal format (YYYYQ). Y stands for year (here four digits) and Q for quarter (single digit: 1,2,3, or 4). The separator (‘.’ or ‘/’) has to correspond to the date format in the user settings. Features Permitted entries for the date format DD.MM.YYYY are QYY (
Read more: Conversion , Routine

PERI6 Conversion Routine
2008-08-22 08:57:07
Use Conversion routine PERI6 is used with six-digit entries for (fiscal year) periods. Features The internal format for six-digit periods is YYYYPP (200206, for example, for period 06 of fiscal year 2002). When the external format is converted to the internal format, this checks whether the entries in the INPUT parameter with external date format (separators, order) comply with user settings. T
Read more: Routine

PERI7 Conversion Routine BI InfoObject
2008-08-22 08:56:40
UseConversion routine PERI7 is used with seven-digit entries for (fiscal year) periods.FeaturesThe internal format for seven-digit periods is YYYYPPP (2002006, for example, for period 006 of fiscal year 2002). When the external format is converted to the internal format, this checks whether the entries in the INPUT parameter with external date format (separators, order) comply with user settings.
Read more: Routine

POSID Conversion Routine BI InfoObject
2008-08-22 08:56:13
Use The POSID conversion routine converts the external presentation of the program position (0PROG_PO_EX) into the internal presentation (0PROG_POS), using the active master data table entries for the program position InfoObject (0PROG_POS). Example Conversion from the external into the internal format: P-2411 ® P24110000
Read more: Routine

PROJ Conversion Routine BI InfoObject
2008-08-22 08:55:52
Use There are extensive possibilities in the ERP system project system for editing the external presentation of the project and PSP elements (project coding, editing mask). These features are included in the ERP conversion routine. This comprehensive logic cannot be mapped in the BI system. For this reason, the characteristic 0PROJECT_EX exists in the attributes of InfoObject 0PROJECT and the ext
Read more: Conversion , Routine

REQID Conversion Routine BI InfoObject
2008-08-22 08:55:32
Use The REQID conversion routine converts the external presentation of the appropriation request (0APPR_REQU) into the internal presentation (0APPR_RE_ED), using the active entries in the master data table for the appropriation request InfoObject (0APPR_RE_ED). Example Conversion from the external into the internal format: P-2411-2 ® P24110002
Read more: Routine

REQID Conversion Routine BI InfoObject
2008-08-22 08:55:11
Use The REQID conversion routine converts the external presentation of the appropriation request (0APPR_REQU) into the internal presentation (0APPR_RE_ED), using the active entries in the master data table for the appropriation request InfoObject (0APPR_RE_ED). Example Conversion from the external into the internal format: P-2411-2 ® P24110002
Read more: Routine

IDATE Conversion Routine BI InfoObject
2008-08-22 08:54:48
Use This conversion routine assigns the appropriate internal date presentation (YYYYMMDD) to an external date (01JAN1994, for example). Call up the test report RSSCA1T0 to be able to better visualize the functionality of this routine. This test report contains the complete date conversion with external as well as internal presentations. Example Conversion from the external into the intern
Read more: Routine

Conversion Routine RSDAT BI InfoObject
2008-08-22 08:54:24
Use Converts a date in an external format into the internal format. Features First, the system tries to convert the date in accordance with the user settings (System ® User Profile ® Own Data ® Fixed Values ® Date Format). If the system cannot perform the conversion in this way, it automatically tries to identify the format. Valid formats: DD.MM:YYYY MM/DD/YYYY MM-DD-YYYY YYYY.
Read more: Conversion , Routine

Page 2 of 3 « < 1 2 3 > »
Copyright 2006 - 2007. TopBlogArea.com All Rights reserved. Created by SEOMinds.com
eXTReMe Tracker