Not all corporations want their employees to access dashboards through BI Launch Pad (Infoview). Some may want to access dashboards through a third-party website or portal such as MS Sharepoint. Unfortunately, a logon prompt will pop up if a user tries to execute a live query when they are not logged into BI Launch Pad.
So we will need some sort of hidden login mechanism that bypasses the pop up to refresh data on the dashboard. In our example, we assume that there is one login that can view dashboards. Using that login we will then populate the CELogonToken, which then allows authentication to occur transparently.
Create a dashboard that has a connection to either a Query as a Web Service object or Live Office object. In this recipe, we create a QaaWS object, using the eFashion 1997 demo universe. Select the Month dimension and Sales Revenue measure as the Result Objects. On the Filter insert Holiday...