I have created a SQL Server stored procedure (under Programmability option) and wish to run it and have its output stored as a fact table in the Elasticube. Then will Join this fact table with other tables as part of my Elasticube design.
I also want to run this stored procedure every time when the build is executed so that fresh data could be added to the output file.
Can someone please guide how to do this, with relevant screenshots or if can point me to some articles which explain this.
Thanks in advance
Please sign in to leave a comment.