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 just got lumia 920 5days ago and now I can't access to my phone settings. Can't even go into settings to open wifi or other things. Tried soft reset also can't. Tried My Window Phone to remote erase phone also can't. Here is the link: http://http:/ [More]
Hi, I created a new business document : Purchase request that once it is validated we can copy it to Puchase order. when i save the purchase order doc and then launch the creation of the purchase order the operation succed. But when i try to copy an [More]
I made a slideshow in iDVD and tried to burn it onto a DVD. iDVD informed me that my Intel iMac did NOT have a 'Superdrive' and could therefore not burn it. Strange: this Intel iMac does indeed have a DVD-burning 'Superdrive'. What gives?This frequen [More]
Hi, I have a requirement, Smartforms output contents needs be converted as HTML File and it should be sent as email. I am able to get the Smartforms output in html format but the output is shown as binary format. After the fm call the job_output_info [More]
i cant get my camera to work it says its on but has no feedback, any ideas?Here are my best suggestions for your camera problem: • If Apple's http://support.apple.com/kb/HT2090    suggestions do not help you, (the "reset" suggested there    ofte [More]
Ok, heres a dumb question for most of you. When you are done editing a picture, the jpeg options box comes up, and you have to choose small or large file size, and high or low resolution. (Also medium, too)  Do I want high resolution for a "quality&q [More]
my update was stopped in the middle, and next time i tried to restore and update, i cannot do any thing now, the error code (16) apprear all the times, my network, cable, windows, security, every thing is fine, plz help.Hello, talatafaq.  Thank you f [More]
I just finished a project in InDesign which was then exported to PDF to make a slide show of 517 slides, each with a title that was bookmarked by creating a Table of Contents in InDesign. My problem is that all of the titles were in the form of 000-A [More]
Hi all, do you all know how can I get to the configuration tab in MAX? Thanks. =)It seems like you are asking almost the same question here.  Just put the two questions in the same thread.  Continue there.Read other 2 answers [More]
I can't download The Bible ap because I need 4.3 update but all the updates are done on my iPad <Subject Edited by Host>The original iPad can be updated to iOS 5.1.1. All more recent iPads can be updated to iOS 6.1. If your iPad is running an iOS ve [More]