Shubh M Posted July 8, 2019 Share Posted July 8, 2019 Hello Folks Can we aggregate the data while adding data table in spotfire I have huge amount of data in my source table, and I dont want to get all of that in my spotfire (huge loading time).I am thinking while am adding my data table from data connections, there itself if i can aggregate it somehow, it will reduce my loading time + remove all unnecessary data + smaller dxp file. I dont have access to Information designer and it's being handled by another team, so this question. Please correct me if i am wrong, applying pivot transformations at the data table level is not going to help me here, beacuse all the data is already imported in analysis file. Pivot is going to apply transformations later once data loading is done in analysis. Please let me know if any more details required on the same. Thanks Best Regards Shub Link to comment Share on other sites More sharing options...
Seema Krishnani Posted July 8, 2019 Share Posted July 8, 2019 With the Information designer, you should be able to perform pivoting on the server. please check the below link https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_pivoting_data.htm Please also check the below KB and let us know if this helps https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-48050 Also would using custom query be another possible solution https://support.tibco.com/s/article/How-to-add-a-custom-query-in-a-data-... Link to comment Share on other sites More sharing options...
Shubh M Posted July 8, 2019 Author Share Posted July 8, 2019 Thanks a lot Seema for your quick response. But all the above links will work after data loading is done in analysis file, not while adding/loading them. I do not have the access to create custom SQL or access informaiton designer in any way, so was wondering if i can perform aggregations while adding data table from an existing Information link. Thanks Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted July 8, 2019 Share Posted July 8, 2019 Hello Shubham, I agree with your understanding that pivoting will happen once the data is brought from the source to the Spotfire Server. If you do not have access to the Information Designer, then you won't be able to modify the SQL query accordingly. The other option would be to use a custom query using Data Connectors as suggested by Seema and write your own aggregated SQL query. Reference: https://support.tibco.com/s/article/How-to-add-a-custom-query-in-a-data-... Link to comment Share on other sites More sharing options...
Shubh M Posted July 9, 2019 Author Share Posted July 9, 2019 Thanks Shashank, As i said, custom SQL option is not feasible option for me at the moment. Let's see if we can find out anything else. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now