[Gary Tennessen]

I have created a few simple dashboards, but it appears that they only look at today's data. I need to use a date variable so that I can look at previous dates data.

I know that when I create the dashboard, I need to select the "CONTEXTUAL" option.

In Composer, I have created the Assisted Request with a "Date" variable, and when I run it standalone in Sentinel, I get prompted for a date. This allows me to look at previous days data.

The Assisted Request SQL looks like this, with Date being the variable:
WHERE EventDate='TrkParameter(Date ?,XFBTRANSFER,EventDate)'

When I run this Assisted Request in a Dashboard, there is no prompt for a Date.

My Dashboard has a variable tab, where I create the Date variable, and give it a name. I gave it the same name as the one used in the Assisted Request.

My DataSource Request has a parameter tab, and I also define the variable here.
TrkParameter(Date ?,XFBTRANSFER,EventDate)'

My Indicator Request also has this in the SQL
WHERE EventDate='TrkParameter(Date ?,XFBTRANSFER,EventDate)'

What am I missing? Why does my Dashboard not prompt for the variable?

[Tony]

Gary, I got the following information a while back and hadn't gotten too much time to play with it. I was trying to do the same thing, in that we wanted to be able to view data for a specific date. It seems like it shouldn't be too complicated, but this solution is a bit tough and would probably require involvement from DBA/Security because of the permissions needed to set up some of the database stuff. Let me know if you have any luck, I'll be digging into this specific functionality next week hardcore!

I attached a sample dashboard (XML file you can import), and here are the instructions I received-

Here is the simple example to use Dashboard variable, all you need to import the dashboard (xml file) and create a table in your sentinel database (Sentinel database user)

Description of table
SQL> desc tony
Name Null? Type
----------------------------------------- -------- ----------------------------

NAME VARCHAR2(10)
NUM NUMBER


insert values to the above table
SQL> select * from tony;

NAME NUM
---------- ----------
test1 1
test2 2
test3 3
test4 4
test5 5
test6 6
test7 7

Now send the dashboard to production + in the dashboard viewer you can change the value in dashboard variable à you see the desired output

Attached File(s)

 New_test_dash_sql.xml ( 9.69K ) Number of downloads: 9