Sitemap

Amicuk Programming Answers

Hello, i m looking for the guide  how to

-0001-11-30   Views:0

Advertisement

Hello i m looking for this guide called how to, i m begining in BW and some one told me about this guide its very useful, some of you have it? or where can i find it? i ll give points, thanksHi Go through the basics of any Data Warehousing book. Then

Hello i m looking for this guide called how to, i m begining in BW and some one told me about this guide its very useful, some of you have it? or where can i find it?
i ll give points, thanks

The replay answer
Advertisement
Hi
Go through the basics of any Data Warehousing book.
Then go through the step by step  modelling  by Fu Fu.
U can enhance the BW skills more by SAP press realses by Norbert Egger.
SDN is always good for all.
If you got an acess to BW server go through the steps ... basics of modelling
BW 7.0
Uploading of master data
Log on to your SAP
Transaction code RSA1—LEAD YOU TO MODELLING
1.     Creation of Info Objects
•     In left panel select info object
•     Create info area
•     Create info object catalog ( characteristics & Key figures ) by right clicking the created info area
•     Create new characteristics and key figures under respective catalogs according to the project requirement
•     Create required info objects and Activate.
2.     Creation of Data Source
•     In the left panel select data sources
•     Create application component(AC)
•     Right click  AC and create datasource
•     Specify data source name, source system, and data type ( master data attributes, text, hierarchies)
•     In general tab give short, medium, and long description.
•     In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , )
•     In proposal tab load example data and verify it.
•     In field tab you can you can give the technical name of info objects in the template and you not have to map during the transformation the server will automatically map accordingly. If you are not mapping in this field tab you have to manually map during the transformation in Info providers.
•     Activate data source and read preview data under preview tab.
•     Create info package by right clicking data source and in schedule tab click star to load data to PSA.( make sure to close the flat file during loading )
3.     Creation of data targets
•     In left panel select info provider
•     Select created info area and right click to select Insert Characteristics as info provider
•     Select required info object ( Ex : Employee ID)
•     Under that info object select attributes
•     Right click on attributes and select create transformation.
•     In source of transformation , select object type( data  source) and specify its name and source system Note: Source system will be a temporary folder or package into which data is getting stored
•     Activate created transformation
•     Create Data transfer process (DTP) by right clicking the master data attributes
•     In extraction tab specify extraction mode ( full)
•     In update tab specify error handling ( request green)
•     Activate DTP and in execute tab click execute button to load data in data targets.
4.     Monitor
   Right Click data targets and select manage and in contents tab select contents to view the loaded data. Alternatively monitor icon can be used.
BW 7.0
Uploading of Transaction data
Log on to your SAP
Transaction code RSA1—LEAD YOU TO MODELLING
5.     Creation of Info Objects
•     In left panel select info object
•     Create info area
•     Create info object catalog ( characteristics & Key figures ) by right clicking the created info area
•     Create new characteristics and key figures under respective catalogs according to the project requirement
•     Create required info objects and Activate.
6.     Creation of Data Source
•     In the left panel select data sources
•     Create application component(AC)
•     Right click  AC and create datasource
•     Specify data source name, source system, and data type ( Transaction data )
•     In general tab give short, medium, and long description.
•     In extraction tab specify file path, header rows to be ignored, data format(csv) and data separator( , )
•     In proposal tab load example data and verify it.
•     In field tab you can you can give the technical name of info objects in the template and you not have to map during the transformation the server will automatically map accordingly. If you are not mapping in this field tab you have to manually map during the transformation in Info providers.
•     Activate data source and read preview data under preview tab.
•     Create info package by right clicking data source and in schedule tab click star to load data to PSA.( make sure to close the flat file during loading )
7.     Creation of data targets
•     In left panel select info provider
•     Select created info area and right click to create ODS( Data store object ) or Cube.
•     Specify name fro the ODS or cube and click create
•     From the template window select the required characteristics and key figures and drag and drop it into the DATA FIELD and KEY FIELDS
•     Click Activate.
•     Right click on ODS or Cube and select create transformation.
•     In source of transformation , select object type( data  source) and specify its name and source system Note: Source system will be a temporary folder or package into which data is getting stored
•     Activate created transformation
•     Create Data transfer process (DTP) by right clicking the master data attributes
•     In extraction tab specify extraction mode ( full)
•     In update tab specify error handling ( request green)
•     Activate DTP and in execute tab click execute button to load data in data targets.
8.     Monitor
   Right Click data targets and select manage and in contents tab select contents to view the loaded data. There are two tables in ODS new table and active table to load data from new table to active table you have to activate after selecting the loaded data . Alternatively monitor icon can be used
Hope this helps
Cheers
Sunil

Go to See the other 4 answers

[Guide] Install and run Windows 7/8 from an external drive without using bootcamp (works for late 2012 iMacs with 3TB drive)

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

This is a copy of a post from my blog, you can also Read it on my blog... Introduction After I received my new iMac with a 3 TB Fusion Drive, I was disappointed when I realized that Bootcamp was not running on this model and prevented me from install[More]

Guide: Optimizing Your Windows XP/Vista Notebook

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

purpose: to build a highly optimized, personalized, faster, smaller and more secure OS installation using windows xp (can use vista also but this guide will not cover it in any detail) plus i was bored to tears information: this is a somewhat advance[More]

SharePoint Foundation 2013 guide

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

hello guys, getting off my hands to get wet on sharepoint. need a guide on how to setup document management using sharepoint foundation thanks. Every second counts..make use of it. Disclaimer: This posting is provided AS IS with no warranties or guar[More]

New .TV (pets, recipe, etc.) and Viacom channels not in zap2it or Tivo guides

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

So, it's been about a month since the new .tv channels came out and two days since the Viacom HD channels were introduced.  And zap2it.com, Tivo, etc. all still don't list ANY of the new channels in their programming guides. I've opened cases with Ti[More]

Channel Guide Update - Questions & Concerns

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

In speaking with customer support this morning, it would appear that my only recourse for letting Verizon know that I don’t like the new Channel Guide is to make a post on the forums and this seems like the most applicable one. To start, there was ab[More]

Got my password wrong twice and my mini is disable. I connected to iTunes, but can't get it to work. Can some one guide my through?

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

got my password wrong twice and my mini is disable. I connected to iTunes, but can't get it to work. Can some one guide my through?If it's showing the red disabled screen due to incorrect passcodes then you may need to put the iPad into recovery mode[More]

Follow-up to archived thread "Another Error (I think) In the 12.1 New Features Guide"

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

I hoped to be able to add a reply to the most recent reply on March 8 in the "Another Error (I think) In the 12.1 New Features Guide" thread (https://community.oracle.com/thread/3526588), but since that thread has been archived, I am doing what[More]

A PC buying guide for NLE (mainly Intel)

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

For AMD setups, disregard the mentions of sockets and the like but the general recommendations still hold. When you need a new PC for editing purposes, you basically have three choices: 1. Buy an off the shelf system from companies like HP or Dell. 2[More]

Overclocking the i7, a beginners guide

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

To give credit where credit is due: This was not written by myself. I have only edited parts of it. I found this on the internet, but it was such a great article, that I wanted to draw your attention to it. Credits go to Chad. Thanks for all the effo[More]

Lenovo U310: Clean Windows 7 Installation Guide (including Rapid Start and Caching)

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

Hi there, this is the first time that I am writing such a guide/tutorial/whatever you may call it – there are probably better ones, but though not being a total computer noob, it took me almost one week to get this pretty (now again) little beast run[More]

If you format in Guid for Intel Macs, Apple partition for PPC Macs for Boot drives, then why do my PPC Hard drives Boot in my 2007 Mac Pro, what gives?

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

  I recently purchased a 2007 Mac Pro for a song, swapped the CPU's for octo chipsets and proceeded to wait for new Hdd's in the mail. I was told the Hard drives in my old G5 would not be bootable unless they're in Guid format. Disc Utility confirmed[More]

Hot
I have a Macbook Pro early 2011 running on mountain lion version 10.8.2. A while back, i purchased a mini display port thru HDMI port so i could watch dvds on my toshiba television. it all worked great for a while, then the sound just stopped working [More]
Hi, We have a client requirement to add 5 fields (In selection screen) to report painter reports ( Reports of CJE3 and GRR3 ).We created Z reports as a copy of standard reports, added required 5 fields by implementing SAP notes and other settings.We [More]
Hi, I'm trying to create some WebI reports over BW Queries, but when I try to refresh the WebI document, it throws an error that more less says "timeout during allocate / CPIC-CALL: ThSAPCMRV", I know that Note 1032461 is related, but unfortunat [More]
How do I set up home sharing to display music from shared library by artist and album?I am not sure if the fix that cuatro476804 suggested is the issue here.  I have also been experiencing freezing issues with my Apple TV since the latest Apple TV/iT [More]
I have a table with a long raw column. I am using the following to try to delete the row from a copy of 8i Lite: stmt.executeUpdate("delete from blobs where blobid="+blobId); My application hangs at this point. Any theories? I am using this driv [More]
I need a information about inventory ,can anyone provide me inventory related PDF,docs it will helpful for my projectinvetory administration link http://docs.oracle.com/cd/E26180_01/Platform.94/ATGCommStoreGuide/html/s0302atgcommerceinventoryadminist [More]
Hello I am setting up some lab network . I have 10  Cisco 1900 series switches . But when i try to power up it shows the below message. I am not able to get into user privilege mode. Catalyst 1900 Management Console Copyright (c) Cisco Systems, Inc.  [More]
I bought this phone for my wife who point blank refuses to use it as it has no back button. Is there a workaround to this? ThanksTry telling me what she's having issues with? http://helpblog.blackberry.com/2013/07/blackberry-q10-tips-tricks-blackberr [More]
Ok I have and iPhone 4 I am trying to fix and have literally tried everything and no matter what I have tried nothing seems to work. Please help I will list thing's I've done. My iPhone is in Loop mode only when I plug it in to wall or computer or el [More]
Hello, I got the following configuration: NFS-server: Always on, connected via LAN. NFS-clients: 2 computers, connected via LAN and WLAN. On standby: auto umount NFS-share via system-sleep-hook with systemd. This works flawlessly some hours or even d [More]