Real time cubes with access & filters

Modified on Thu, 14 Mar at 12:06 PM

How to have real time cubes with column, data access & retrieval parameters


The real time cube query will store the meta data only. As and when any crosstab, tabular, graph are accessed, which are created from this cube, the cube query is fired on the database directly. No actual data in stored in our proprietary cube formats, except for metadata.


Administrator can provide Column level access to different users as shown in the below screenshots (Role 1 can view SalesQty, Role 2 can view GrossSales)







Also Administrator can Data access permission (Role 1 can view Alcoholic Drinks data, Role 2 can view Non Alcoholic Drinks data)





Based on the above details, when the analysis is open by User1 having Role 1, Smarten Business Intelligence Suite will query the database accordingly and fetch data relevant to User1. i.e. out of 1000 rows, only 10 rows which is relevant to User1 will be fetched from the database.


Retrieval parameters can also be made available for the BI objects (crosstab, tabular, KPI, graphs)  and will reduce the number of records on the front-end objects by filtering cube data.





Thus increasing real-time cubes performance using access filters and retrieval parameters.


Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten version you may be using

real-time cube data access column access retrieval parameters backend filters frontend filters performance Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article