How to sync database latest data with Analysis service

Hi,

I am creating sql server reports using analysis service(using cubes and dimensions).

After creation of cubes and dimensions for existing data I deployed it. Then I created reports on this data. Reports are generated properly for existing data.

But the report is not showing newly inserted data to database (latest data inserted after deploying analysis service). Did I miss anything? Or any new configuration required?

Newly added data is reflected in report when each time I process the cube and dimension and redeploying it. which is a manual process.

How to auto sync newly added data into database with cubes?

Any help would be appreciated.

Thanks

You can use the Synchronize Database Wizard by right-clicking on "Databases" in Object Explorer (SQL Server Management Studio)

See:

http://msdn2.microsoft.com/en-us/library/ms189349.aspx

Hope this helps,

Santi

|||

HI,

This option Synchronizes one analysis service database with another.

But in my case analysis server database should be Synchronize with RDBMS database(sql server)

Thanks,

Deepak

|||Try proactive caching. In partition tab in cube builder, click Storage setting, and select enable proactive caching. You can apply this setting to partition, dimension, measure group and cube.