Solved

Problem on retrieving data from SQL Analysis service

Posted on 2014-10-07
1
79 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
export all data from one table to multiple text files 4 69
How to calculate iops? 12 27
Sql query 34 20
sql query Help 12 29
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now