Elastic Cube Filter or Data Source Filter

Comments

16 comments

  • Avatar
    Malinda Jepsen

    It depends on where your data is coming from. If it's coming from a SQL Server view, I update the view. Otherwise, yes, you will need to change the SQL code that brings in the data to filter the data (as far as I know anyway!).

    0
    Comment actions Permalink
  • Avatar
    Hamza Jap-Tjong

    Hi Lokender,

    If you want to filter the amount of records coming into the ElastiCube, then you will need to adjust the query when selecting your datasource.

     

    If you want to exclude/include certain fields then this is possible from the ElastiCube Manager by selecting a field and unchecking import

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    okay for example if i have a field called Country and i do not want to bring the data for 1 country in the elastic cube then i have to write and modify my sql query . Correct me ?

    0
    Comment actions Permalink
  • Avatar
    Hamza Jap-Tjong

    Correct

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    Thank you so much Hamza. I am quite new to Sisense and started it today itself .  Can i have your email id where i can contact you directly or your skype id where we can connect because i am sure i will be running into lot of issues in the future .

    Another question is that when i am dragging different dimension into the widget to create a text table then i am not getting the scroolbar instead i am getting numbers to navigate . See the screenshot below . is there any way i can use scrollbar instead of the below 

     

    0
    Comment actions Permalink
  • Avatar
    Hamza Jap-Tjong

    If you want a scrollbar instead of pagination, then you need to change the amount of rows in the (pivot)table. The default is 25. When using a regular table you could also use infinite scroll

     

    Connect with me on Linkedin and i will send you my email. Rather not post it online

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    Thank you hamza for the clarification. Another thing is refrence to my earlier question . I came to know that if i apply the where clause to remove some data from the table then it would not be good for the performance .  Somebody suggested that i can apply those filters at the dashboard level which i think i can do very easily . But i want to ask you that those filters which i will apply will be visible to the end user ?

    I want that whichever flter i want to display to the end user should be there and which i dont want them to see they should not be able to see . Is it possible to do that in sisense ?

    if yes then how can i do that 

    Also i sent a request to you 

    0
    Comment actions Permalink
  • Avatar
    Hamza Jap-Tjong

    Including a where-clause in your query having an effect on performance is correct. If that effect is significant depends on your exporting datasource server. Very simply put; a SQL-server with 1 core would perform less compared with a SQL-server with 4 cores

    Filtering your data can be done on different levels. Lets use the example of a table with sales data and a field that describes the country.

    1. Edit your import query with a where clause to exclude Country X

    2. In the ElastiCube Manager, create a custom table which does a select * on table X where country != 'Country X'

    3. Use data security rules to automaticly exclude Country X always for certain/all users

    4. Use a filter on dashboard level to exclude Country X. This filter is shown. You can 'filter' a filter so it only shows the country you want them to see. But a dashboard filter is visible for your users.

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    Thank you Hamza for the detailed explanation. I already created an elastic cube and ran the build yesterday. Is it still possible to convert it into query and if yes can you tell me  step by step which options i need to choose and where i need to go to do this along with screenshots then it will be very helpful for me  as i am completely new to it. Sorry i am asking too much questions and explanation on the same day 

    But a big thank you for explaining me in details 

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    Hello Hamza 

    Few Questions and Doubts 

    1) i want to use pivot table instead of normal table. is there any way i can remove pagination over there? Seems like it allows only till 200 

    2) When i am building pivot table i am noticing that Column names are repeating again and again . Instead i want the result to look like below . Is it possible

    from the below screenshot you will see that Albama is appearing only once in the State Dimension and all the possible  value corresponding to the Alabama are displayed against it but if i try to do the same in Sisense Albama will appear multiple times . Can you help me if i can achieve this in Sisense or not. The below screenshot is from Tableau

    3) My 3rd Question is that i want Dashboard Tabs in Sisense. For Example if i have to create 3 different dashboard in same file which i was doing in Tableau then there were different tabs were there to navigate within single tableau workbook. If someone wants to see sales related Dashboard they will click on the sales Dashboard Tab and if someone wants to see Country wise Profit they can Click on its respective tabs so that they can see that dashboard . Basically its a navigation to different dashboard from the same tableau file. I want to know if the same can be done in Sisense 

     

    Thank you in advance for all your help on my queries. 

     

    0
    Comment actions Permalink
  • Avatar
    Hamza Jap-Tjong (Edited )

    1. Not to my knowledge. Maybe with javascript.

    2. I think you might have chosen a table by accident. When I pick Pivot Table in Sisense it looks the same as your screenshot.

    3. Sisense does not support 'worksheets' similar to Tableau or Excel. However you can choose the Jump to Dashboard, Tabber or Accordion plugin to let users navigate to other dashboards or let them switch between visualisations

    0
    Comment actions Permalink
  • 0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    Hello Michael

    The script worked for me and exactly the same which i was looking for . i used the second script which was my requirement but one more thing i wanted to ask is that is there a way i can define infinite or something instead of hard coded number because once the data gets refreshed the rows will increase and then again i have to edit the script and modify the number . Is it possible ?

    Also i have sent a request to you on Linkedin. I would like to know and learn more from you since i am new to Sisesne.and i would definitely require lot of help and questions from you 

    Thank you in advance 

     

    Regards

    Lokender

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Lokender,

    I would strongly recommend to avoid going above 1000-1500 lines limit especially with lot of measures, it can have negative impact on browsers' performance for end-users up to a moment when it will simply collapse and not work. If you need infinite scroll and still want some measures to be used go for Aggregated Table - https://www.sisense.com/marketplace/aggregated-table/

    Regards,

    Michał Becker

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    `Thank you Michael . Actually lines are not more than 500 so i think it will work for me. Also i have some other Doubts for which i would like to connect with you. Can we connect on skype or anything else . can you ping me your skype username ?

    0
    Comment actions Permalink
  • Avatar
    Lokender Singh

    Hello Hamza 

    i am using Pivot Table only . The above screenshot which i posted earier from Tableau i am getting the same result in sisense but as soon as i apply filter on it the view does not appear to be what i am looking for .

    0
    Comment actions Permalink

Please sign in to leave a comment.