Improve company productivity with a Business Account.Sign Up

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

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

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
mburk1968
Asked:
mburk1968
1 Solution
 
Rainer JeschorCommented:
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
 
mburk1968Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

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