reema
Data Storage
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Drill down from one dataset(sql table 1) to another(sql table 2).
Thanks again for the different insights! Can I know what type of datasource you connected to in Sisense? As the loading speeds vary right with different types of Datasources. Just curious as Our's would be more than 100's of million's of records that too using Traditional SQL Server and not cloud based.4.6KViews0likes1CommentRe: Drill down from one dataset(sql table 1) to another(sql table 2).
Thanks Hamza, that helps. But I also want to know if there is any way to drill down from say a Summary/Datamart(Subset of Original Table) to the actual Original table having millions of records without compromising on the calculations in a dynamic way. But I think there must be limitations to it in case of this scenario. As the client requirement is to Show only few records taken from a psuedo table like a summary for quick access. And then drill down to the Big Table(with millions of rows). As when I tried to drill down from (Order_Year in Summary Table) to the (Select Order_Date(YQMWD) in Details Table) it drills down the date properly, but gets wierd values in Revenue Column(Which is taken from Summary table and not from Details Table). When Revenue column is taken from Details Table it gets proper Revenue values on Date Drill Down. So just wanted to know if there is any dynamic way of drilling down from one small table to another big table and not compromising on the Values/Calculations. I guess it would have to be done using Jump To Dashboard feature to link to more detailed dashboards as mentioned in the links given by you. As values in both tables will vary and not connected with each other. Anyways thanks! I shall check the BLOX Options mentioned by you. As I just need to do a POC for now as to what are the different options for Optimizing the dashboard for big SQL Server Tables, with a user friendly design. And I guess these should do the job. 🙂4.6KViews0likes3CommentsDrill down from one dataset(sql table 1) to another(sql table 2).
I am fairly new to sisense. I have this situation as below: I have connected sisense to a "Sample Sales" SQL Server Database with 2 Tables: Database : Sales_db Tables : tb_sales_summary : 2. tb_sales : In Sisense I have done an inner join on these two tables on field "Order_year" just to keep things simple for fetching data on drill down. [My approach may be wrong here.] My concern is how do I drill down from tb_sales_summary to tb_sales table, say for example to get the quarterly, monthly, by week, days report with correct calculations for revenue. Drill down like: Year, Revenue Quarterly, Revenue Month, Revenue, etc In the Sisense Dashboard I want to show Year, Revenue fields both from Summary table[tb_sales_summary] only as it will be faster that way on first glance. Instead of showing a Pivot of details table getting the Summary[On dashboard : which can take more processing time in case of millions of records] and then drilling down further in the same table itself, Is there any way of drill down between 2 tables i.e first showing a Summary table(which will show up faster) which is then able to Drill Down into Details Table(tb_sales) as it will be more efficient that way. I found this on sisense community where they say there are limitations with Pivot table for performing drill down between different details or views. Let me know if there is any other approach for same. https://community.sisense.com/t5/build-analytics/what-are-your-preferred-ways-for-making-a-lot-of-details/m-p/1381#M67 Any help is appreciated! Thanks!4.7KViews0likes5Comments