The workspace database, whether locally or on a server, is recreated every time the model is opened in your development environment (Visual Studio or Tabular Editor). Open your model.bim file...

Sure, you're adding rows to the fact table but ultimately it will keep the fact table narrow and you're aggregating a single fact attribute.

In my opinion, create a dimension for Financial Agreements. The dimension would contain all descriptive attributes of the agreement. Create a separate dimension for Asset, which can either have the...

Response duplicated for some reason...please see the other response.

• This reply was modified 1 year, 4 months ago by  Martin Schoombee.

To answer your first question...yes it would not be impossible to do that, but it would be tricky because your data source(s) would need to be accessible by each on...

• This reply was modified 1 year, 6 months ago by  Martin Schoombee.

Ed's questions are all spot on and you should look to try and answer all of them as part of your troubleshooting process.

My two cents: I'd start with a trace...

• This reply was modified 1 year, 9 months ago by  Martin Schoombee.

Can you share the details of the two plans, and the query?

Here's a few articles/blog posts that describe techniques you could use to make this happen:

https://bennyaustin.com/2014/02/20/dynamic-processing/

https://www.sqlservercentral.com/articles/dynamically-process-ssas-cube-from-ssis-package

It will require a little bit of work, but yes...if you can identify the partition it belongs to, you should be able to dynamically build the refresh query in SSIS...

Yes, assuming it is possible to add other dimension keys into the new fact table, it should always be your goal to have all the relevant (conformed) dimensions linked to...

True, I see you can only use table hints and not query hints. why are you trying to enforce the parallelism?

What have you tried and what are you struggling with? Posting the details of your attempts and the output vs. what you're trying to get as output will help us...

Your best option would probably be to create a view (with the table hint), and then use that in SSAS.

• This reply was modified 2 years, 6 months ago by  Martin Schoombee.

No worries, and only if you really want to 🙂

The pattern to do that is similar to inventory snapshots, where you'd like to return the last record of each product/item. More info on how to do it here: