cancel
Showing results for 
Search instead for 
Did you mean: 

multisource unx universe with Audit Table and SAP BW Tables

Former Member
0 Kudos

Hi All,

My scenario is to connect Audit Table in BO 4.1 with Time Dependent Table in SAP BW ( DSO).  while creating Multisource Connection with Audit Tables and SAP BW in Data Foundation Layer, i have default column as Reference Date in BW which is mandatory , i want to know what is the significance of it because when i try to select  one column from SAP BW and one column with Audit Database iam not getting any values when i checked the script it was having a where condition with reference date,

Iam not getting any data because of this, pls let me know how to proceed further.

Regards,

Bala

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi all,

pls let me know whether any of u have faced similar situation.

Regards,

Bala

amitrathi239
Active Contributor
0 Kudos

Hi,

Either put some static date value in the data foundation layer. Right click on the table and edit the input column and enter value. After that your report will work.

Other way create one object in the business layer for reference date.at the time of reports building create prompt in the reference date and use in the report.

This is happening as your cube/DSO is time dependant.

Try with this.

Amit

Former Member
0 Kudos

Hi Amit,

Thanks for the response, if i use static value for reference date  assume iam entering april 04 2014 in reference date if i dont have data for that then it will receive null values because when i checked the script it  is using where condition with reference date. pls let me know how to avoid reference date from the table

regards,

Bala

amitrathi239
Active Contributor
0 Kudos

Hi,

You cannot avoid reference date because your cube/DSO is time dependent. If you will create report via BICS also you will get the date prompt.

Instead of putting static date create one object in universe with reference date and use in the webi query as prompt and see if it is working or not.

Even I have searched about this  but could not find anything. After that I have created reference date object in the universe and used in the webi report.

Amit