B.I. for newbies

[Former Member]

Hey SCN! Good day to you all. Me and my team are "newbies" on SAP NetWeaver's B.I. (B.W.) and seeking help for us to make our practice set work. So, for our practice set, we're using a flatfile for us to generate data inside SAP.

Maybe you can help us guys figure out what we did wrong a while ago and also tell us the way it supposed to be done.

(Flatfiles are already made.) First, we created an InfoArea in the InfoObjects tab of the Modelling Workbench. Next we created an InfoObject Catalog (Characteristics). Here, we created our InfoObject Characteristics then followed by making our InfoObject Catalog (Key Figures) and same thing goes, we created our Key Figures here. Next is that we jumped to the DataSource tab of the Modelling Workbench and there made our Transaction DataSources. In this stage we import/mount the flatfiles to our created DataSources and we think eveything went well. Next, we jumped to creating our cubes. We created 4 cubes created characteristics and used some templates for the key figures and again, we think we did just fine on that part. (Are we already missing some important parts?) Unfortunately we really got lost in creating Transformations, DTPs and Infopackages. We did some of it on our cubes (InfoProvider tab) and some on our DataSources (DataSources Tab), but yes, we didn't get any data to monitor (maybe some wrong declarations where to point this and that etc.).

So I hope you can help us guys and we'll let you know if we manage to make it work. Thanks for your help in advance PROs!

Cheers!

[Former Member · Accepted solution]

hi,

create transformations between cubes and the DS and then create a DTP for it and load data from DS to cube.

regards,

Arvind.

[Former Member · Accepted solution]

Thanks for the quick reply Arvind. I'll let you know asap if it worked, latest by tomorrow. We're now out from work. )

[Former Member]

Oh! It's already working. I just have to restart SAP, that is :). Thank you so much guys for your help! More practice sets to go!

[Former Member]

Is this the right way to get my characteristics in the cube? I have to put my pre-made characteristics in Dimensions 1 or I have to make new Dimensions?

[Charactersitics|http://i591.photobucket.com/albums/ss352/ekis0609/characteristics.png]

Maybe this is the problem why my key figure is the only one showing as the displayed data.

Edited by: Xyruz.Duka on Aug 5, 2011 3:44 AM

Edited by: Xyruz.Duka on Aug 5, 2011 3:50 AM

Edited by: Xyruz.Duka on Aug 5, 2011 3:50 AM

[Former Member]

Well guys, we had the chance to see our data FINALLY. UPLOADED AT LAST! but now, we only got to see one column from our flatfile. Can you tell us what's wrong? Thanks (oh btw, we'll be doing this all over again, today so we'll update you guys again in a bit).

[Former Member]

Hi

Check the mappings between Info objects and falt file fields in your data source.

Are you able to see the data of your flat file in preview tab of data source...?

Regards,

Venkatesh

[Former Member]

Yes, I can see the whole data of my flatfile in the preview tab. And I believe the mapping of our info objects are correct.

[Mapping|http://i591.photobucket.com/albums/ss352/ekis0609/mapping.png]

[Former Member]

I'll update you guys asap thanks!

[Former Member]

One more thing, unfortunately we were not provided of the process for DSO. So basically, we just wanted to check if we imported our flat file the right way.

Thanks Again.

[Former Member]

for loading the data into dso you have to perform all the steps which you have done for cube.there are three tables in DSO,

Activation queue,change log and active table.After DTP data goes into the activation queue of DS0.Here the data is not activated,so to activate it right click on DSO and choose manage option.there is a request tab in which data load details will be present.Select the request id and activate it .

[Former Member]

Hi

Welcome to SDN

Follow the below steps to load the flat file to CUBE

1)Create Info area

2)Create Info object catalogs for characteristics and Key figures.

3)Create the characteristics and key figures as per your requirement.(for date and time use standard info objects)

4)create the application component-- click on source system ---> here source system used to load flat file(PC_FILE). and create AC.

5)Create the data source under application component.

6)fill the required fields and check the data preview here.

7)Create Info package to load the data from flat file to Data source.

8)Create Cube and assign your characters to your dimensions.(time characteristics will automatically moves to Time dimension)

9)Create transformation between your Data source and CUBE.

10)Create the DTP and load the data to CUBE.

Please go through the below article

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60debae1-84dd-2b10-e7bf-bdedf1eabdf9

Hope this helps

Regards,

Venkatesh

[Former Member]

Sorry for the late update guys. As much as we wanted to learn where our mistakes are, it ends up we're still lost (a bit, that is :P). We started all over again and doing one .CSV file (flat file) at a time, we define our characteristics and key figures. Bank Name, Bank Type, Account Type, Account Code for our Characteristics then for our Key Figures we have Minimum Balance. (This only a practice set, please do tell us if we are missing some components). So everything's set, now we created a transformation from our data source to our cube (btw, we placed (drag and drop from our workplace) our defined characteristics to 'Dimension 1' of the Cube - is this the correct way to do it?). However, we manually did our mapping and the error that we are receiving is only for the time characteristic, which RSA, auto designated to a 0HALFYEAR1 (can you tell us what's wrong here?). Now, we think everything's fine so we saved and executed. As of the moment here is our result from our executed DTP

[DTP Result|http://i591.photobucket.com/albums/ss352/ekis0609/DTP.jpg]

Now how do we check if what we did was right? (Did we miss some important procedures or whatsoever?)

Thanks Pros!

Edited by: Xyruz.Duka on Aug 4, 2011 8:58 AM

[Former Member]

Hi,

Welcome to SDN !!!

For the scenario you have mentioned you can check following things,

1) For all the datasources you have created Infopackages, once tha IP's are ready you can goto execute tab and in the preview you can see how the data will be loaded in PSA.

2) Now once data is avaialble in BI system in your data sources you will have to create transformation from Data source to Cube or DSO, generally we put DSO inbetween loading data from PSA to Cube so as to support the delta mechanism, as DSO have the overwrite property and cube have addition.

3) Once you create transformation from Data source to Cube you will have to create DTP's for these transformations. In the transformation you can do the field mapping from source field to target field. If you have proposed any infoobjects in data source defination under Infoobject column then transformation proposes the automatic mapping of source and target field, otherwise you will have to do manual mapping.

4) If you put DSO in between then you will have to activate the data once it is loaded to DSO for further loading in cube.

5) Execute the DTP's and your data will come to InfoCube.

Regards,

Durgesh.

[Former Member]

Thanks for the solution Durgesh. We'll let you all know by tomorrow guys but we really do appreciate your quick replies. KUDOS SCN!