Report Programming - Variables - Add “Days From Current Date”
Home > Reports (infoAdvantage) > Job Aids > Report Programming - Variables - Add “Days From Current Date”
This job aid describes steps for adding custom time elements in infoAdvantage.
Time Element: Days From Current Date
This allows a user to prompt on “Days From Current Date”. With this, a user can schedule reports to give you yesterday’s data, for example. Follow these steps:
Start by selecting either Design or Structure mode for your report.
In the top menu bar under Query, click on the grid with a cog (Edit) icon to edit your query.
Click the Add Query button to create a query.
Select the Data Source “Universe”.
Click OK.
Select the universe “FIN – Current Date”.
Click OK.
In the left panel (data outline panel), click on the > (caret) icon next to the Calendar Date folder to expand the section below. You should now see the Dimension called “Calendar Date”.
Now you can either
Click, hold, and drag the Calendar Date dimension, or
Click it and then click on the > arrow in the Result Objects section to move it over.
Again, in the left panel (data outline panel), look for “Days From Current Date”.
Now you can either
Click, hold, and drag the “Days From Current Date” measure, or
Click it and then click on the > arrow in the Query Filters section to move it over.
In the dropdown menu next to the query filter you just added, select “Equal To”.
Click the three horizontal lines (define filter type) on that same filter to select “Prompt” for the input.
Now you need to add another time element in another query.
Go to another query for the report and add a time element to the Query Filters.
This particular example is adding a filter for Dimension “Vendor Address Effective End Date” that is Greater than or Equal to specified prompt.
Click on the three horizontal lines (define filter type) and select “Result from another query (Any)”
In the new window, look for the query you have created for the Calendar Date dimension.
Click on the dimension “Calendar Date”.
Click OK.
Now the data will contextualize to the Calendar Date dimension. The list of dates generated by the report will be based on your prompt input for “Days From Current Date”
