sql query



1 comment

  • Avatar
    Ravid Paldi

    Hi Michal, 


    You use Custome queries to generate a new table in many different scenarios. For example, if you'de want to use 2 similar tables in one widget, then you'll need to merge the two tables in the cube into one and then use that one. 

    Another example can be in order to reduce the size of the table to improve the performance of the dashboard 

    Another example can be when you want to perform calculations that you can't do on the fly in the dashboard for various reasons (so you'll prepare the calculations in a new table during the build process in advance) - this one is actually pretty common. 

    Ping me if you need any help (: 




    Comment actions Permalink

Please sign in to leave a comment.