2 Replies Latest reply on Feb 20, 2013 9:39 PM by Jaan N

    Display value from a static table that has no relationship with other tables.

    Jaan N

      I want to display one field in dashboard that can be changed from database to database. This value stored in a separate table that does not have relationship with any other tables.

      Few options i tried are

      (1) Creating a static join in my datasource. This is working fine. But i do not want to extract the same value on each row of the resultset.

      (2) Tried creating a parameter to store this value separately. After publishing the dashboard, i changed the data connection to use some other database and did complete refresh. All other charts are displaying data from new data base but this parameter is still holding the value from old database.

      Is there any way to achieve this ?

      Please help me in resolving this issue.