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
Hello Today I tried to use the harmonics distortion analyzer VI and it seems that there is an error in the VI (or I misunderstood something...). The phenomenon I observed can very well be shown in the attached example. Description: - THD - calc: outp [More]
I have a family of seven. Five of us all have Apple Ipods or Iphones. Everytime there is a new update for itunes or any of us try to plug our devices into the computer to hook up to itunes we all have problems or it won't let us!...It's getting to th [More]
Hi, How to configure the system to validate duplicated invoice by REFERENCE AND VENDOR NUMBER irrespective of dates? This validation need in FV60.Hi Paul, if you want a duplicate invoice check from the FI side, then you may have to activate BTE 1110 [More]
When I back up my contacts from my iphone to my PC how do I know they are backed up? If I back up my pictures they appear on my PC. But if I back up my contacts and can't find them on my PC are they backed up? Thanks.Do you have Sync Contacts selecte [More]
Hi All, I am struggling with this problem: I have a 2D array 50   62 73 82 91 96 100 43 78 146 186 230 255 0.25 2 6 12 20 5 50 500 2000 8000 5 50 500 2000 8000As a general rule of thumb, given a 2-D array with a set number X and Y the unique number o [More]
I would like to unlock my iphone 4S I have a locked iphone 4S (AT&T Carier). What must be done to unlock this phone to use the other carrier in my localOnly way is to contact the carrier to officially unlock the iPhone. https://www.att.com/deviceunlo [More]
Hi Expets, Good day!! I have a sceneario, downpayment to be create at purchase order level not on purchase order line item level.  Downpayment is belongs to whole purchase order level. As per sap standard system is asking Item to be entered (mandator [More]
Pages has crashed on me, several times in fact. I can actually crash it at will. but it doesn't mean lost work, and i find that very odd. i am running on an intel mac mini, a few months old, not the latest core 2 machines, and Pages will crash each a [More]
HI All, I've spotted another prob with X-FI2 whichI think may be linked to it not recognising all albums on the player. Has anyone else noticed that if you go to the DJ option and choose Random Play All, it chooses only 00 tracks (the same tracks eve [More]
When will the iphone get audio directions in the maps app like the droid?We have no idea when, or if, spoken directions will ever be added to the iPhone as a default feature. There are, however, other apps available from third-party developers that p [More]