Seeking Best Practice for Live Detail Reporting in Sisense (Replacing SSRS)

Afternoon Sisense community,

Our team is looking to replicate the functionality of a crucial SSRS report within Sisense. This report is used by a department to obtain a detailed list of jobs for a specific month. The workflow involves:

Running the report for a selected month (typically the current or previous month).
Reviewing the output for discrepancies.
Updating the source system based on the review.
Re-running the report immediately to verify the changes (requiring live data).

Current Sisense Implementation & Performance Issue

I've attempted to recreate this report's dataset using a Live Model connected to a Redshift SQL View. The view is complex:

It contains approximately 50 columns of detailed data.
It involves JOINs across 15 different tables to consolidate all necessary dimensions and metrics.

The Issue: The performance of this Live Model is unacceptable. Users are accustomed to the SSRS report running a stored procedure and returning the filtered data in under 30 seconds. My Sisense Live Model is timing out.

Constraints & Goal

Requirement: The data must be live (no ElastiCube, as users need immediate reflection of system changes after updates).
Target Performance: Sub-30-second return for monthly filtered data.

Request for Guidance

Given the high number of columns, multiple joins, and the strict requirement for live data with fast filtering (specifically by month), what would be the recommended best practice for implementing this detailed report in Sisense?

Are there specific Sisense configurations, data modeling techniques for live connections that would address this performance bottleneck while meeting the "live" requirement?

Thank you for your insights!

Luke Flett

Posted 10 months ago·Last reply 8 months ago

6 comments

DRay

·8 months ago

Hi Laflet,

Were you able to get this resolved?

DRay

·9 months ago

Hi Laflet,

I'm checking in to see if you were able to get this resolved.

DRay

·10 months ago

Hi Laflet,

Just checking in to see if you still need help with this.

Luke Flett

OP9 months ago

Yes

DRay

·9 months ago

Hi Laflet,

I am reaching out to your account team to check on getting you a technical resource to help.

DRay

·10 months ago

Hello Laflet,

Thank you for reaching out. Due to the specific and complex nature of this request, I have contacted your account team to get you connected with a technical resource that can assist you directly.

Here are several posts that I think you will find useful also.

https://community.sisense.com/t5/knowledge-base/maximize-dashboard-performance/ta-p/9483

https://community.sisense.com/t5/build-analytics/7-tips-for-better-sisense-dashboards/td-p/12234

https://community.sisense.com/t5/product-and-website-news/maximizing-performance-insights-why-sisense-offers-a/ba-p/20121

Can you take a look at those and let us know how it goes?