June 29, 2017 at 2:42 pm
Hello, I have created a tabular cube in 2016 format, and I've created a pkg that executes a query on the source external db, and loads into the target table on SQL Server. What are the objects and any coding I may need to simply load the data from the newly loaded SQL Server table into the cube? This would be a first time load. I'm turning a query and its results and turning into a regular running cube. I would like to also empty the cube for each run. Any help is appreciated. Thanks
June 29, 2017 at 4:34 pm
Please let me rephrase, I have a Pkg that loads a SQL Server table from an exec query from another system. I have a new cube that has the structure I need, and I can also process it manually fine without error. I now need to what objects I need to add to the SSIS pkg to trigger the cube to process after the table loads. I'm familiar with doing this through the kludge of partitioning tables and procs, but not a simple object to trigger the execution of the cube to process without all the partitioning table objects.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply