My application has a Values table that shores some custom values that are imported by the user. the user can catagorize the data with a lookup table called ValuesType.The user also has the available to create new entries in the ValuesType table.
The user can then access an OLAP interface that I have developed and browse the Values table by putting the Values measure sliced by the desired ValuesType dimension.
When the user create a new entry in the ValuesType table, I need to update the ValuesType dimenson in the cube to reflect the addition.
Which processing method should i use? I read http://msdn.microsoft.com/en-us/library/ms345142%28SQL.90%29.aspx#sqk2k5_asproc_topic3 and i think Process Update is the one that I should be using?
Also, when i need to process the data to update the olap, I should be using Process Update. Correct?
View Complete Post