• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 98
  • Last Modified:

How to set the SSAS in Sync Mode ? How to set the Cube to refresh data to the most recent transaction.

How to set the SSAS in Sync Mode ? How to set the Cube to refresh data to the most recent transaction.

My Cube is able to fetch the data till one day before to the current date in the Production Log Table.

We are expecting the cube to fetch the data till the last log from Production.

How do we achieve it ? Is something, I am missing while creating the cube ?
0
chokka
Asked:
chokka
1 Solution
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hello,

That will occupy too much resource but this can be done simply by SSIS Analysis Services Processing Task.
Set a SQL Job which triggers when we get new log in the Production Log Table.
The job will run this ETL package and will process the Cube and the cube will have fresh data at each process.
0
 
chokkaStudentAuthor Commented:
Okay thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now