The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Ganeshk12's avatar
Ganeshk12
New Contributor
1 year ago

Dashboard - load issue (default parameter value)

  Hi, All -  I’ve developed a dashboard that includes a text box, parameter components, and other elements. Users can input a date and click a trigger button to fetch the data, using inbound para...
dashboards
Ganeshk12's avatar
Ganeshk12
New Contributor
1 year ago

Hi sameburn  - Thank you

I have updated the query like this still having an issue and will try the one you suggested. thank you !

 

        SELECT 
            Username, 
            MAX(LastLogonTime) AS LastUpdatedDate 
        FROM 
            UserLogonStatus 
        WHERE 
            LastLogonTime <= CONVERT(DATETIME, '|!logonThreshold!|')
        GROUP BY 
            Username

 

 

rhankey's avatar
rhankey
Contributor III
1 year ago

I think the problem is that |!logonThreshold!| is not being replaced with the date/time.  Temporarily replace that parameter with the 1/1/1900 12:00:00 AM and confirm it works, as it appears it should.

If the above test does work, then you can move on to figuring out why the dashboard parameter is not being replaced, or is being replaced with some other text string that cannot be resolved to a date/time.

The dashboard parameter will only be substituted if the Adapter is set to CommandType=SQL.  And when you run the adapter, it should display the SQL statement before and after parameter subsitution.

If you are issuing the SQL statement from within a Business Rule, it is on you to take care of constructing the SQL statement with any runtime variables.