new records in tables not reflected in dashboards built based on web intelligence reports
santhoshlakshmi (BOB member since 2014-08-06)
new records in tables not reflected in dashboards built based on web intelligence reports
santhoshlakshmi (BOB member since 2014-08-06)
Need more detail than that, what type of connection, QaaWS BIWS, LiveOffice, other? What are the refresh options set to?
cdavies (BOB member since 2005-01-28)
dashboards created based on webi reports. In connections selected Refresh components when loaded.
Web reports fetch data from dwh tables.
when tables have new records inserted it is not showing up in dashboards
santhoshlakshmi (BOB member since 2014-08-06)
Sounds like you need to expand the range of the spreadsheet binding to accommodate the new rows, it’s not dynamic.
cdavies (BOB member since 2005-01-28)
No I had extra cells binded already. When I manually go and refresh the reports and save it to enterprise then only its getting reflected. Any options to make it update whenever changes made in table
santhoshlakshmi (BOB member since 2014-08-06)
How are you binding the WebI report? Via Bi Web Services, QaaWS, or Live Office?
cdavies (BOB member since 2005-01-28)
via webservices
santhoshlakshmi (BOB member since 2014-08-06)
On the properties of your webservices make sure the Refresh option is set to 1.
cdavies (BOB member since 2005-01-28)