Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How do I refresh my cube each EOM with new/changed data?

Posted on 2015-01-14
2
211 Views
Last Modified: 2016-02-18
I have a Claims EOM Snapshot Dimension.  Every time I add new or changed data to this dimension, I receive errors when I go into SSAS and try to process my Cube.  It states that the ClaimsEOMKey doesn't exist, but in fact it does...at least it does in the equivalent database dimension.  How do I refresh the SSAS Dimension w/the new/changed data?  I refreshed the DSV, but that didn't help.
Please see attached...
Experts-Exchange-SSAS-Cube-Processing-Er
0
Comment
Question by:mburk1968
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 40550601
Hi,
hm, from the attached word document the naming looks like your source is a fact table / view.
You have to ensure that the related dimensions get processed before the dependent dimensions get updated.
But without more details about the SSAS database structure (cubes, dimensions, facts) it will be hard to track it down.
Can you try a full process of the SSAS database? Or will this take too long?
HTH
Rainer
0
 

Author Closing Comment

by:mburk1968
ID: 40551053
This worked, however, I guess I'm not exactly sure what the difference is between Process Full for the Cube in VS and Process Full for the SSAS database.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

I'd like to talk about something that is near and dear to my heart: build systems. Without them, building software is all about compiling locally, with software versions everywhere. It can be a mess. Today we are going to discuss building a small di…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

839 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