Avatar

Scott Vickers

  • Total activity 42
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 11
  • Subscriptions 16

Activity overview

Latest activity by Scott Vickers
  • Avatar

    Scott Vickers created a post,

    Query timeout after 30 seconds with generic ODBC connection

    Currently using v6.7.1.14501.  Normally we use the out of the box SQL connector and it pulls data from very long running queries just fine.  I am trying to switch to the generic odbc connector so I...

  • Avatar

    Scott Vickers created a post,

    C:\ProgramData\Sisense blow up to 85 GIGS

    Answered

    This folder started getting huge and eating up all our disk space on one server.  We keep our cubes on a different drive, is there any way to clean this up or store it elsewhere?  Seems abnormally ...

  • Avatar

    Scott Vickers created a post,

    pastmonth() and pastyear() in 6.7

    Answered

    Looks like these functions broke on all our widgets after the 6.7 upgrade.

  • Avatar

    Scott Vickers commented,

    To get the jaql query for a specific widget you can follow the instructions in this article: https://support.sisense.com/hc/en-us/articles/115002802107-Extracting-Retrieving-Results-from-Widgets-to...

  • Avatar

    Scott Vickers commented,

    The tokens do not expire right now.  

  • Avatar

    Scott Vickers created a post,

    Stripe Subscriptions

    Answered

    Any way to get individual subscriptions into a table in our cube?  The customers table has a column for the subscriptions but it is just a json array.  AFAIK we can't parse the json into a custom t...

  • Avatar

    Scott Vickers commented,

    If any wayward travelers come across this, here is the answer: ([Total quantity],all([Years in transactionDate]),all([Quarters in transactionDate]),all([Months in transactionDate]),all([Weeks in tr...

  • Avatar

    Scott Vickers created a post,

    Using All() with a date field.

    Answered

    Is this possible?  I want a measure in a pivot table to ignore the date that is used as a filter for the dashboard it will live on. ~~

  • Avatar

    Scott Vickers commented,

    In 6.5.2 the prediction options are missing from the menu. 

  • Avatar

    Scott Vickers commented,

    Any way to set the ranges via a function?  Would be super cool to base them on quartile or something similar.