Create two or more data sources and mapping to DSO
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!
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?
Turnover in Euro.
(All currency is in Euro)
Profit in Dollar.
Profit in Euro.
Profit in Yen.
Profit in different currencies available.
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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,
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