Thanx for the quick reply.

1. Its mean After merge process it will contain 2001 and 2002 year data but if we do not change the where clause then after full Reprocess(is it reprocess only for partition or cube )  we wil have only 2001 data.

2. In Merge partition video after doing the reverse engg, 2001-2002 partition(In MergedPartition project) select statement have correct where clause with out moodification on analyais sever.  Its mean without chaging the where clause on analysis server we are getting the correct where clause in MergedPartition project.

3. What is the metadata. How we can define the metadata in ssas?

4.In first time aggregation, We have objects counts(Estimated count and partition count) before the aggregation. Can we define aggreagation percentage based on  counts i.e If counts is 1 lacs then 10 % etc. Actually during interview time one comapny asked me that how we know(With out usage based optimization)first time aggregation paercentage.

5. In Objects counts, is it Estimated counts also includes the partition counts?

Regards,

kamal maurya

I have query given below

1.  How to improve the cube processing time of the large cube? What steps we have to follow for it.

2. Sales persons can see only his sales location . how to implement this security functionality?

3. Attribute rigid type is improved the Cube processing time. What is the logic behind it? How the cube processing engine work in this scenario?

4. We have cube name "SampleCube' on server. If we try to deploy the same name cube i.e. "SamlpeCube' on the server again then what will happen?

5. How to know how many username go through the cube.

kamal mauya