Dashboard Connection

[#1]

New to Dashboards, but have been working with Crystal Reports for years. I'm trying to determine if a dashboard can be connected directly to a database rather than the static summary dataset on the dashboard. Or is there a way to make the dashboard real-time?

Thanks

[Former Member]

Hi Rodney,

Unlike CR there is no option to connect to database in Dashboard.
The reason behind this is the database has large data. And dashboard is actually to visiualize highly summarized data. And hence, the recommended number of rows of data is 512.
Ofcourse large number may work but 512 is recommended.

In the Data tab -> connections -> you can add webi services. (QAAWS created on unv and BIWS created on webi)
In order to connect to BEx query and unx directly you can make use of Query browser.
We also have Live Office where you can add unv,webi,cr report.

You also have other connections but these are  mostly used by everyone.

There are lots of helpful documents and discusssions here on SCN you can go through it.

@Krishna: You cannot schedule the dashboards. I guess you mean we can have dashboard get data from the scheduled instances of report.

Regards,
Abhilasha

[former_member202170]

Abhilash :

Yeah when we schedule the webi report only it latest data come and reside in Dash Board

getfromlnstestdocument instance = TRUE..

No dash Board itself from the SQL server Stored Procedures can schedule