Dec 13, 2013 at 01:53 PM

feasibility of a webi format !

25 Views

Hi Experts ,

Env : BI 4.0 SP6 , BW ,OLAP Connection , Webi report

I have a order number wise report with 20 columns , for each Order Number there is going to be many transactions happened on different dates.

In report i want to show the latest record of each order number (max date for each order number) initially , If user interested to see details happened on that order number then he needs an expansion .

Report is holding >30000 rows .

I tried to create Element link with 2 tables , 1 is master with max date info and other with details .Because of huge data with 20 columns that is getting struck.

i don't want to go with hyperlinks because of maintenance.(Each transport , need to manually change hyperlinks).

Can this achievable in the same report ?

Thanks