You need to use a process incremental. If you are doing this from SSIS you can use variable expressions to build XMLA to process only new data.

Process Update is for dimensions only, not facts. I take it you are talking about facts since you can't partition dimensions.

With the following you would be selecting everything:

UNION({[Question].[Classification Name].&[Overall Experience]},

STRTOSET("[Question].[Classification Name].[All]", CONSTRAINED)))ON COLUMNS

You are choosing a specific member followed by the All member. Also you seem to be using UNION...

I've done this before in SSAS.

Basically, all of your SCD 2 logic should be in your source data - so your surrogate keys in your facts map to the...

In that case you can use the same logic. For 2008 in the Precedence Constraint simply evaluate the value (which I'm assuming is a variable at this point) to itself...

In your SQL Agent job step where it asks for server, use the target server (this is where the script will be executed and what you will synchronize to).

Have a look at this:

http://www.bidn.com/blogs/DustinRyan/ssis/915/check-isnumeric-with-derived-column-transform-in-ssis-package

Hi Tony,

This is a good question and the answer is.......it all depends 🙂

If you go with your first solution, yes it would affect processing and size and you'd be best...

Without knowing any more detail it's impossible to provide you with any sort of solution. Firstly as a guideline, just imagine creating the code in T-SQL, think of all of...

Have a read of the following: download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

Pay attention to the Processing and Server Tuning parts.

Have you tried a trace on your source SQL instance to see if it could...

er.deepikagoyal (11/25/2014)

---

But my manager wants to have different cube for different fact table (His own concerns :angry: )

That's the reason i have landed up making 15 different cubes. any solution...

Okay, this is tabular right? Even if it's multi-dimensional you don't need a separate cube for each fact table. You can have 1 cube and use either perspectives (http://msdn.microsoft.com/en-us/library/gg492105.aspx) or...

If you're not going to use the fact table anyway then why bother importing it? Just ignore it and import the one that you actually need.

er.deepikagoyal (11/25/2014)

---

Thanks for the same!!

Quick questions :

1. How to process whole SSAS database : In SSIS, i can see option of processing only Cube

2. Every time processing the whole...

What I mean is you need to process the whole AS database, not just the cube.

As for restricting what is seen in excel when a user connects, you can...