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 am using sip communicator.to run it i ve installed ant and jdk1.4 .also set the path.then i run the bat file of sip communicator and configure it also.bt i cnt established the call.thr is some errors. again i am using my sip server.its domain name [More]
Hi, I have iPhone 4 with iOS 5.0.1 installed. My company uses Miycrosoft Exchange Server and I have synched my iPhone using the Microsoft Exchange server account option. I don't have any probelm with my emails or contacts. However, the calendar is no [More]
Hey all, Just wanted to report some good news to those of you watching and waiting.  I have a late 2012 27 inch iMac with a 3TB Fusion drive running Windows 8 Pro via bootcamp.  Given the saga earlier this year of a) waiting for BootCamp support on 3 [More]
We have 15 people sharing files on a network. If we open a file on the network, work on it, and save it, it is readable and writeable for everybody. But if we drag the file off the network, work on it on our own hard drive, and save it, and THEN drag [More]
Mozilla Foundation Security Advisories (http://www.mozilla.org/security/announce/), when accessed provides information on many of the advisories, but for some it displays an error that you are not authorized to open. I tried to open bug #790879 & it [More]
Hello, I am wondering if MacBook with it's NVIDIAGeForce 9400 graphic card would handle FC Express 4.0? In the requirements specs, it all looks OK except requirement for Graphic Card. It says this: An AGP or PCI Express graphics card compatible with [More]
i need to see a way if i can turn on find my iphone on my ipad it got stolen when they broke in my home.  what can i do?Report to police along with serial number. Change all your passwords. These links may be helpful. How to Track and Report Stolen i [More]
Hi! I have spent hours on the net searching for an example, that could show me how could I make a flex script that user could browse (like fileReference.browse() ) for a file (picture) and then show this picture in the browser (so the source of some [More]
I've installed finally 10gR3 and have a look at the Folios. It looks great. I was wandering if anyone has integrated Folios with SiteStudio. What I was thinking of, was the contributors using a Folio for defining the structure of the web page. With t [More]
Please note that we are having a problem with respect to unplanned depreciation run in Quality. I made the change in the configuration in DEV and transported this to Quality however when we started testing this in Quality we were getting the attached [More]