Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 93
  • Last Modified:

Problem on retrieving data from SQL Analysis service

I have created a cube with SQL Analysis Service and I'm sure data has been loaded into it. When I clicked Sept data, it can retrieve properly but it doesn't work on Oct. Any idea what I can check further ?

Tks
Result1.png
Result2.png
0
AXISHK
Asked:
AXISHK
1 Solution
 
lcohanDatabase AnalystCommented:
Did you checked the underlying Cube Fact/Dimension tables? How/When are they populated after the initial population?
Also the cubes must be processed after OLAP fact/dimension tables data is refreshed from the OLTP tables.

https://social.msdn.microsoft.com/forums/sqlserver/en-US/e513c546-c923-4719-a3aa-b2549c5f5eca/incremental-cube-load-in-ssas-cube
http://www.informit.com/articles/article.aspx?p=1842938
http://www.ssas-info.com/forum/7-analysis-services-forum/551-ssas-cube-incremental-load
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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