cancel
Showing results for 
Search instead for 
Did you mean: 

how to display the data provider sql name in webi report

0 Kudos

Hi,

i have Webi report have 2 sql's in same universe.For ex: Sales and Purchase. I wanted to display the sql name in the report header.

If i refresh Sales than it should display "Sales" Samething if i refresh Purchase sql than display will "Purchase".

If Refresh All than Empty.

Can someone can help me to achive this.

Thanks in advance.

Thanks & Regards,

Kumar.

denis_konovalov
Active Contributor
0 Kudos

I have fixed your tag, please select more careful next time.

Accepted Solutions (0)

Answers (1)

Answers (1)

daniele_tiles2
Active Participant
0 Kudos

hi,

You can use the LastExecutionData(“DataProviderName”) to print the last execution date of each provider.

So my suggestion is to make a table with 2 rows (one for each provider ), so you can see the last execution of each provider. You can’t reach what you mean, only if one of the provider has never been refreshed