Jason,
Thank you for your thoughts -- all of the data warehouses I've worked on have only used date dimensions, so my questions are more theoretical at this point.  I...

Jeff,

Would you really use a Time datatype for a Time dimension primary key?  I guess it would really depend upon the granularity of your data, but slicing down...

Can the user select a date range after they've selected one of the four options?  If not, just have one dropdown with your four values:

1 ...

An integer takes four bytes in SQL Server, while char(4) would also take four bytes.  Since you're never going to have a number larger than 2359, you could use a...

It sounds like you have a bigger issue than SSIS.  If the users have query permissions to the database (even if you could shutout SSIS), what's to stop them from querying...

I've not personally done much with tabular (just multidimensional), but it sounds like you're going to need to investigate partitions.

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/partitions-ssas-tabular

I hope this helps,
Rob

No -- as you've found out.  You either have to drop the FK references, truncate and readad FKs or DELETE (if a lot of records, do in batches to...

Are you trying to Pivot your data?  https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot

Rob

So where have you started? What do you have so far?  What about some table DDL -- that will make it easier for people to help you.  I'm assuming your fields...

I didn't think you could step though your .Net code with a breakpoint in 2008 R2?

You might have to default to using what we called back in the day,...

It's going to be hard to give you much help without  little more to go on.  I'm guessing you updated your underlying Fact table.  What was your update statement(s)?  What...

I'd say whack the files you don't want in explorer.  Take a look at this: http://www.ssas-info.com/analysis-services-scripts/2679-script-to-backup-ssas-database-and-delete-old-backup-files to see if that provides any help.

Rob