Avatar

Yoni Lerner

  • Total activity 244
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 6 users
  • Votes 0
  • Subscriptions 125

Activity overview

Latest activity by Yoni Lerner
  • Avatar

    Yoni Lerner created a post,

    How To Calculate The Maximum / Minimum Date Per Categoty On Pivot2

    Introduction This article will explain how use MAX() / MIN() functions on date fields using Pivot2 and based on this article for old pivot. Business Case Sometimes we need to present the last / fir...

  • Avatar

    Yoni Lerner created a post,

    Fixed Column Size for Pivot2

    In some cases for design or reporting you would like to control the size of your pivot2 columns. The example bellow is for a table with 4 columns 0-3 // Add new width for desired columns// Columns ...

  • Avatar

    Yoni Lerner created an article,

    File Management Automation for File Managment

    On article Uploading Files Locally Using Rest (Linux) we saw examples of how to automate the upload of files to File Management. This article describe methods to automate the management of files on...

  • Avatar

    Yoni Lerner created an article,

    Use CSV and Excel From Hosting File Sites - FTP/S3/DropBox/GoogleDrive etc'

    When using one of the file hosting sites (HTTP or HTTPS, Amazon S3, Azure Blob Storage, Google Drive, Box, Dropbox, Sharepoint, AzureDataLakeStoreGen2, AzureDataLakeStoreGen2 with SSL, FTP or FTPS,...

  • Avatar

    Yoni Lerner created an article,

    Uploading Files Locally Using Rest (Linux)

    In Sisense Linux distribution you are able to upload files to the local environment using Droppy, which is embedded in the Sisense platform. Power-Shell 1 file upload Example The script below will ...

  • Avatar

    Yoni Lerner created an article,

    Custom Domain - Re-Branding the URL

    In some cases, a customer would like to have his own domain instead of the *.sisense.com provided by Sisense team.  If you wish to use your own domain please follow the steps below -    Windows Ge...

  • Avatar

    Yoni Lerner created an article,

    Connecting to CDATA JDBC Connector

    There are many additional DB that don't come as part of Sisense out of the box, however Sisense has a partnership with CDATA a data access and connectivity solutions company. Using Sisense Generic ...

  • Avatar

    Yoni Lerner created an article,

    Secured DB Network Connections

    To connect to your DB (SQL Server, Oracle, Redshift, AD etc') you will need to choose one of our supported secure data transfer solutions. Once selected reach out to your customer success manager s...

  • Avatar

    Yoni Lerner created an article,

    Connecting to Cloud Apps from a Dynamic IP

    Your cloud backend application (Rdweb, FTP and restart services) are limited only to whitelisted IP's to keep your environment highly secured. In case you don't own a static IP or working out of th...

  • Avatar

    Yoni Lerner created an article,

    Access your Customer Data folder CSV/Excel

    When inserting files in the Customer Data FTP directory the access to this folder is different between the Web Elasticube Manager and the desktop one   For example - We've moved the test excel file...