Stop processing cube to update data from original DB in wijmo OlapServerIntro

Stop processing cube to update data from original DB in wijmo OlapServerIntro

Posted by: m.omar on 8 January 2018, 12:50 am EST

• 

  m.omar

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 January 2018, 12:50 am EST

  I successfully implemented my first example of wijmo OlapServerIntro by following the steps in the following links :

  https://www.grapecity.com/en/blogs/using-asp-net-core-mvc-web-api-render-ssas-cubes-part-1

  and

  http://demos.wijmo.com/5/PureJS/OlapServerIntro/OlapServerIntro/

  but unfortunately i notice that every time data criteria changed in my client test page, wijmo OlapServerIntro “processing cube to update data from original database” , what i expected is to retrieve the result from cubes without “processing cube to update data from original database”.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 8 January 2018, 7:30 pm EST

  Hi Omar,
  
  If we understand correctly, you would like to prevent updated data retrieval for DataAnalyses uisng DataEngine service for SSAS cube on changing PivotPanel.

  Please confirm this.
  
  ~Manish

• 

  m.omar

  • Post Options:
  • Link
    Copy

  Posted 9 January 2018, 5:50 pm EST

  Yes , confirmed…

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 January 2018, 7:57 pm EST

  HI Omar,
  
  Currently, this feature is unable. We have created an enhancement request for the same with TFS id 304713.

  We will update you once we get any update on this.

  ~Manish

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 25 January 2018, 5:15 pm EST

  Hi Omar,
  
  Could you please confirm the following example meets your requirement:

  The data is retrieved from the Database for Some fields and after retrieving data using Data Engine service, some user updated records in Database.

  Now the you do not like to get these updated records from the Database using Data Engine service on PivotPanel field changes.
  
  <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

  ~Manish

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2018, 12:05 am EST

  Hi Omar,
  
  Here is the comments from Developer:

  As per my understanding, for cube source, the DataEngine web api cannot control that.

  It is configurated by the cube source. If the cube is stored in MOLAP, we can only get the old aggregated data.

  In other modes, we could get the aggregated data from the real time data.

  You can refer to the detail information from the following link:

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4db4603e-c61e-4cb8-8c7c-042c2ab6cb49/update-data-in-an-ssas-cube-after-the-production-database-is-changed?forum=sqlanalysisservices

  https://www.databasejournal.com/features/mssql/article.php/3900331/Introduction-to-SQL-Server-Proactive-Caching.htm

  https://www.databasejournal.com/features/mssql/article.php/3901126/Configuring-Proactive-Caching-in-SQL-Server.htm

  ~Manish