Create two or more data sources and mapping to DSO

Advertisement
Hi,
I´m using SAP Netweaver BI 7.0.
If there are two or three data sources which have to be mapped to DSO which field from Data Sources has to be mapped to which field in DSO?
Is it possible to have only one DSO or should it be three DSOs because of the three Data Sources?
The thing is I have created one view out of three tables. For the view I have created one DSO. Everything worked fine. But now the requirements have changed because of currencies.
The view I have created is now mixing currencies because in the view is only one currency field, which is filled from the three tables. Two tables have different currencies and one table has one currency.
The one currency of the one table is important and should stay like it is.
I´m thinking about something like three different currency key fields in DSO which are mapped from data source. Also for every field of data source mapping with corresponding field in DSO.
Some hints? I have found articles in SDN about creating data sources and so on but they don´t help me in this matter.
Thank you in advance!
Advertisement

Replay

Thank you guys for explaining! I´m new to SAP BW and trying to better understand.
I`ll try it also with the view. It sounds "easier".
But if I´m doing it with the 3 data sources, that means that for each currency field of the data source I will need an corresponding currency field in the DSO for mapping.
Is it possible to have 3 times the 0Currency field in the DSO and each data source currency field will be mapped to the DSO?
If that would work the 0Currency has to be contained in the key figures.
But if the 0Currency is contained in each key figure will the assignment of currency work correct?
+For example:+
Data Source1:
Turnover in Euro.
(All currency is in Euro)
Data Source2:
Profit in Dollar.
Profit in Euro.
Profit in Yen.
Profit in different currencies available.
Data Source3:
Sales in Dollar.
Sales in Euro.
Sales in Yen.
Sales in different currencies available.
For mapping from DataSources to DSO if it is possible to have 3 times 0Currency in DSO:
Data Source1 currency fiield ---> DSO 0Currency
Data Source2 currency fiield ---> DSO 0Currency
Data Source3 currency fiield ---> DSO 0Currency
Does it make sense?

PowerView error -Cannot create a connection to data source 'TemporaryDataSource'.

Hello and thanks for the time. I am getting the following error when trying to create a powerview report.  I don't get where is this TemporaryDataSource is and how do I check the permissions on it?  that is what this error is pointing to, no?  I trie

Problem with the data source and web.xml

I have an issue where JSC is removing my resource reference: <resource-ref> <description>Creator generated DataSource Reference</description> <res-ref-name>jdbc/localOracleDatabase</res-ref-name> <res-type>javax.sql.Dat

Maintaining attributes, data source and attribute list in web UI

Hi Can we maintain attributes, data source and attribute list in web UI level. We can do it  in SAP GUI level but do we have the option of doing it on web  UI level?? Regards AakshiHI data sources and Attribute lists need to be maintained in GUI but

Data Source and Data Store

Are both Data Source and Data Store the same in BI? If not can someone explain what each one of these terms mean. Thanks for the helpData Source or Persistent Staging Area  is a transparent database table or initial store in BI. In this table the req

Non transactional data source and ejb transaction

Inside an ejb method with trans-attribute = Required, Do a bunch of things using a transactional data source and a bunch of things using a non trasnactional data source. Looks like the time spent doing the non-transactional data source related work d

Gateway Service Builder and Data Source Boolean Mapping

Hi folks, I am using the service builder to define my gateway ODATA services ... I have some data model fields which are booleans and are defined as type 'Edm.Boolean' ... I am unable to map those fields to RFC ABAP fields with domain 'BOOLEAN' (char

Error while creating a new report data source in Sharepoint Document library

I installed SSRS(sql server 2012 SP1) in my sharepoint 2013 farm(single server installation). I have installed SSRS addin for report also.  I created a document library and included the report data source content type, report builder report and repor

Having difficulty creating pdf from XML data source

I have a 'rpt' file built with a classic install of Crystal 10, using xml as a data source. I have tried using both ADO.NET(XML) connection and ODBC CR ODBCXML Driver 4.20. The rpt file was built on Windows2000 NT platform. The report runs, and displ

Transporting a Data Source and Hierachie to the Quality System

Hello, i have following problem. I want to transport a  generic data source from our development system into the quality system. In the development system the hierachie looks like New-Hierroot ->CO     ->ABB          ->Datasource ABB When i trans

Version error while creating info package of data source 0fi_gl_10

Dear Friends, I have replicated the data source 0fi_gl_10 into sap bw but while creating info package i am getting error " The DataSource 0FI_GL_10(E01CLNT200) does not exist in object version A". IS the manual activation always should be done f

Dreamweaver CC data source and ser

Hello, I am doing a follow up to the question asked a year ago here: Insert Image using a Data Source I understand there is a deprecated server behaviors extension which i have downloaded and was able to get databases and bindings onto Dreamweaver cc

Data source and Database table

Hi All, I am working on BW and i am trying to figure out the linkages between Database table and the data sources in our source system. I need to figure out which database table is linked to a particular datasource. Please guide me on the process. Th

Logistic Data source and loading sequence

Hi Gurus , Can anyone help me explain the use of the 2lis_02_CGR and 2lis_02_SCN. I also need to know the data loading sequence for the following data source 2lis_02_HDR, 2lis_02_ITM, 2lis_02_SCL, 2lis_02_ SGR, 2lis_02_ CGR, 2lis_02_SCN Thanks for yo

Creating a new ODBC Data Source

I am trying to create a new ODBC connection to Merant OEM 5.2 32-Bit Oracle to connect to an Oracle database. I am using 9.3.1 in a Windows environment. Is there any documentation out there on how to create this connection. Any help will be greatly a

Create two or more GL account in same material grp

Is it possible to create a two or more GL account for material group based on plant level. ThanksHi Elaine, I am not quite sure what are you trying to do. Do you mean material type? Either or the assignments of GL accounts to materials mainly depend

Select Data Source and Microsoft Security Issue

Hi, Tool- Xcelsius 2008, QAaWS When I open dashboard, it gives message "Microsoft Office has identified a potential security concern" "Data Connection have been blocked. If you choose to enable data connection, your computer may no longer b

Loading attribute data via data source and file

Hi gurus, My issue is that when I load excel file(2-column: matnr and werks) and load to master data via IP and DTP. After successful upload all available attriubute values which are retrieved from 0material_attr are gone away. Maybe deleted somehow.

JSC, mysql 4.0 data source and utf-8

Hi all, I connected to mysql 4.0 database from JSC and bound some utf-8 encoded text data to a StaticText component in a JSP page. Data is shown improperly, as a bunch of wierd characters. MySQL 4.0 knows nothing about encodings other than iso8859-1,

Creating a package from Github source and install instructions

hello I've read that the correct way to install things is to make a package from source if it's not in a repository. Install instructions: https://github.com/yaxu/Tidal/blob/mast - l-linux.md I copied /usr/share/pacman/PKGBUILD.proto into the source