1. Login To DAC
2. Navigate to Setup >> Physical Data Sources
and set up connection to the BI server
Optional >> In the extended properties tab add the connection pool ( Note it should match the connection pool name in your RPD)
3. Click Test Connection to test the connection
4. Navigate to Tools >> Seed Data >>
Actions >> Task Action and click new to create a new action to populate
aggregate Enter a name
5.
Click on the Value
filed to open the dialog and add a command to be run by nqcmd
call sapurgeallcache();
6. Navigate to Tools >> Seed Data >>
Logical Data Sources and create a source for the BI Server
7. Goto Design >> Task and create a new task
and associate the action created above in the command for incremental and full
load, choose the logical data source created above
8. Add the task to a execution plan in the
Following Task tab
9. In the execution plan connectivity parameter
subtab click generate and map the logical datasource to the Physical Data
source
