Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • 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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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