0

Predefined variables tips

8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • The following table describes the date variables supported by Incorta Analytics. Please note that If they are used in formula columns of a schema, they are interpreted at load time and stored in memory. But if they are used in Business Schemas or a Dashboard, then they are calculated at query time.

     

    • currentDate Return Date
      • The current date of the Incorta Server time.
    • currentDay Return Date
      • The current day from the Incorta Server time.
    • currentMonth Return Integer
      • The month of the current Incorta Server time.
    • currentYear Return Integer
      • The year of the current Incorta Server time
    • currentYearStart Return Date
      • The first day of the current year: January, 1st, yyyy (time: 00:00:00.000)
    • currentMonthStart Return Date
      • The first day of the current Month: January, 1st, yyyy (time: 00:00:00.000)
    • dayAgo Return Date
      • A date that corresponds to the current hour on a 24 hour clock.
    • weekAgo Return Date
      • A date exactly seven days before the current date (time: 00:00:00.000)
    • monthAgo Return Date
      • A date exactly one month before the current date (time: 00:00:00.000)
    • currentQuarter Return  Integer
      • The current quarter from the system time.
    • quarterAgo Return Date
      • A date exactly one quarter before the current date (time: 00:00:00.000)
    • yearAgo Return Date
      • A date exactly one year before the current date (time: 00:00:00.000)
    • lastYear Return Integer
      • The year before the year of the current Unix Time lastYearStart Date The first day of the previous year: January, 1st, yyyy (time: 00:00:00.000)
    • lastMonthStart Return Date
      • The first day of the previous month, as in: January, 1st, yyyy (time: 00:00:00.000)
    Like
  • Hi, I need the server date and time as column name, just like GETDATE() function in SQL Server. Is there any predefined function in Incorta and I want to set this field as primary key field. I need to take snapshot on this date field.

    Like
  • You can find a predefined variable called $currentTime

    Like
  •     How to use this variable in query while creating the MV.

    If Im using this variable it gives me the error saying Illegal Group reference

    Ahmed Eltanahy

    Like
  • Hi Ahmed Eltanahy

    I have configured SSO for a latest 4.5.8 version    .

    When the user signs in through the SSO URL, they are able to see the dashboard and also apply various filters.

    But when they try to use any of these predefined variables in the Dashboard Filter, they automatically get logged out from the session.

    Is there anything incorrect in usage/configuration? Have you seen any such behaviour?

    Thanks.

    Like
    • Yogesh Bhave Please contact Incorta Support to help diagnose this issue.

      Like
  • Ok Thanks Dustin Basil  will check with Support for the issue.

    Meanwhile just wanted to check , is there any setting/configuration in Incorta to disable predefined variable for time being?

    Like
Like Follow
  • Status Answered
  • 9 days agoLast active
  • 8Replies
  • 367Views
  • 6 Following