You mention that you already have a package that imports the files into a database table. Let’s consider this database table to be a staging table for your data. Now,...

Yes, the incremental load pattern can be used with any data source.

Stick with it for now, you can look for alternative ways later.

Besides the options Koen mentions above, you can use ORA_ROWSCN, an Oracle system column.

Whenever data changes in a block in Oracle, the ORA_ROWSCN gets updated for that table. Use it...

Did you try with a dataflow executing the SP and output to csv file directly?

Based on the information given, it might be easier than writing a script task to create...

I am not aware that SSAS stores the last started value anywhere. If you are ok with using the servers event log, a PowerShell scripts can get it for you:

...

The example refers to large dimensions and how to optimize the load from the database server into the SSAS file structure. The customer dimension is used as an example of...

When the full process is performed on the tabular database, you are still storing the previous model in memory, so you need at least twice as much memory as it...

You can try to change the Placeholder Properties to use HTML instead of plain text.

1: Replace your brackets with <B>, </B> - Replace(Replace(Text, "(", "<B>"), ")","</B>")

2: Highlight your expression, right...

What SQL statement are you executing?

You can get the SQL statement by going to your dim table and select Table/Properties, if data is shown switch to: Query editor.

Your data is likely displayed in scientific notification, just change the data format properties to General

I believe that your problem is your variables are set to be expressions.

In your example the variables are not expressions, so when the variable is being evaluated it becomes...

I am interested in it for spin and let you know my thoughts.

Cheers

Lars

Are you sure the SSAS needs the memory?

SSAS does not grab and hold memory like SQL Server, it only takes the memory that is necessary to keep the model in...

You should be happy that you have your data warehouse. All your data is already sourced, a great place to start with dimensional design.

To your questions:

Is it better to perform…...

You stated “Management needs to be able to review any combination of cost centers based on their criteria on a timely basis”. You should look at something else than a...