March 4, 2016 at 2:25 am
Hello,
as the title suggests i am trying to build a ROLAP Cube on the SQL Server 2012. This Cube is accessing DB2 tables with named queries. So far it is working fine as i managed to deploy the cube and get the data from DB2.
My problem is that the cube caches the data, so that my count gives old values after deleting a row in DB2.
I set all dimensions, the cube, partition and aggregation design to rolap. Further more i disabled proactive caching in these objects.
Do you have any suggestions or ideas on how to make my cube realtime?
March 7, 2016 at 4:49 am
Have you read the following (the ROLAP section)?
https://msdn.microsoft.com/en-us/library/ms174915%28v=sql.110%29.aspx
There are a number of rules that you need to adhere to for ROLAP to work correctly. My guess is it's something to do with SSAS attempting to create indexed views.
Although, after a little bit of googling I found this comment:
"Some features require a SQL Server relational database that runs on-premises. Specifically, writeback and ROLAP storage require that the underlying data source is a SQL Server relational database"
Here:
https://msdn.microsoft.com/en-us/library/ms175608.aspx
It seems to not be supported for DB2.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply