Solved

Problem on retrieving data from SQL Analysis service

Posted on 2014-10-07
1
82 Views
Last Modified: 2014-10-29
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
Comment
Question by:AXISHK
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 40380519
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Replace Dates in query 14 42
sql how to count case when 4 19
sql 2008 how to table join 2 18
Need help with a Stored Proc on Sql Server 2012 4 13
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question