on 01-18-2008 10:36 AM
Hi,
I have a multiprovider with two cubes c1 and c2. I want to copy data with version 0 to version 1 from cube c1 to c2.But if i've 10 records in cube c1 and 5 records in cube c2 .Only the common records in c1 and c2 should get updated in c2 with new version .This means only 5 records should get updated in cube 2 .But the copy function is also adding the remaning records to cube2 which i don't want.I want to restrict updation on the basis of characteristics not on filter.Please help me out to resolve this.
hi
there are two ways:
1. Using Field For Condition: U see ur version 1 c2 cube carefully and find some condition if possible. If u get then filter from c1 only those records using field for condition
2. u can write fox code also for the same: Before copying from version 0 to version 1 just chk using if then else statement whether that record is available in c2 with version 1 if it is present then only copy . (u can use do loop also for this)
regards
srin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.