SSAS cube processing

Question

Hello,

I have a problem with my cube.

I modified data in the fact table then I processed the cube but when I check my data in the cube, I see again my old data.

I processed in Full.

Do you know where is the problem please ?

Thanks for your help.

Answer 1

Hi,

Things to check:

• Are you sure the cube you processed is the same that you are accessing?
• Is the cube data source pointing to the correct database/tables/views?
• Does the tool you use for checking the data not cache results?

You can connect to the Analysis Services database in Management Studio, right click it, and select "Properties". Check if the last update date is when you think you processed it. Then, open the database node, the "Data Sources", and then check the Properties of the data source(s) to which database on which server they are conencting.

Frank

Answer 2

Hi Mimi1255,

Thanks for your question.

Are you doing a process full using SQL Server Data Tools ? If so, please go to "Project- properties of your project", you may need to change "Processing Option" from "Default" to "Full".

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 3

Hi Willson Yuan,

I checked properties in the project and the processing option is Full ("Complet" in French).

But I get the same problem.

My server and database is right.

In Management Studio the last processing:

I do not understand where is the problem. I check the datasource and it is right.

Thanks a lot

Answer 4

Hi FrankPI,

Please check my reply to Willson.
Thanks a lot.

Answer 5

Hi,

do u have some error while processing and the records could be skipped, because u have no Unknown member?

Did process via SSMS or just made a deployment from SSDT (which would I think not automatically process Data if the object is in "Processed State"?

Kr

Answer 6

Hi erveybody,

I found where was the problem.

In fact in Visual Studio, the data source is right.But when I check in SSMS the data source is false.

I Do not understand why. If I change the data source manually it works.

I have to check again my parameters in Visual Studio.

Thanks again.

Answer 7

Hi Mimi1255,

I am glad to know that you have found the root cause by yourself. Please kindly mark the helpful replies as answers. By doing that, it will benefit all community members who are facing similar issues. Your contribution is highly appreciated.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]