Dashboard Components

Hi.

We are currently working on a project for a company to analyse their daily sales. The information is not in the cube, so we are using components such as Charts, Pies and even the BI Viewer to display the information in an attractive way.

This information is not in the cube because the table we use as the database in the application has more than 400,000 records.

Firstly, when working with data that is not in the cube, we cannot add the components we want to a book because the only components (not including cube views) that can be added to a book are charts and reports. For example, if we create a BI viewer, we will not be able to add it to a book.

At this point, we would like you to recommend which would be the best component and how we should prepare a dashboard to have these two characteristics that our customer requires.

- Being able to navigate from one chart to another by clicking on the same chart (open dialogue) (Can be done in advanced chart)
- Dynamic filtering between different components (Can be done in BI Viewer)

The problem is how the client requires these two conditions, if we use the advanced chart we will do without the dynamic filters and if we use the BI viewer we will not be able to navigate from one chart to another (open dialog).

We would like to know if there is a solution that is able to unify these two conditions.