on 05-29-2006 11:14 PM
Hello friends,
We have ODS which was previously not used for BW reportig. Now days we want it to make available for reporting.
when i try to activate the ods in development system it gives error and the ODS is not get activated.
please let me know what can be done to retrive data i don't want any more ods or cube to bebuild but same ods rady for reporting.
Hi Chanakya,
I think we can create similar ODS by copying the structure --> check this new ODS for BEx reporting in Settings and then load the data into the new one from ODS1 and activate.
you can try this..hope it should work.
Hope this helps..
Best Regards,
DMK
*Assign points if it serves your purpose...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Welcome to SDN!
I guess that first you have to delete data from ODS, then make it BEx relevant and activate.
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As far as I remember I switch ODS to accessible\inaccessible for using in reports of BEx whithout delete ODS's data. Special for answer I swith one from my inaccessible for BEx ODSes with active data to accessible and activate them. I get WARNING (not error) click to continue and agree and get good ODS with data and accessible to BEx reporting.
Hi Andrey,
I think, it depends.
I also had an experience when an ODS couldn't be switched off and on for reporting without errors.
I figured that it depends on the following.
If you have already loaded master data for those characteristics used in the ODS, there is no problem with switching BEx relevance off and on (SIDs are already created).
However, if you loaded data into ODS without preceded load of the appropriate master data, and then try to swich on the BEx relevancy, you if I'm not mistaked, should get an error during activation (SIDs not found).
Best regards,
Eugene
PS. BTW, have you used to work with T. Yaroshenko in glob cons?
Chanakya
What error message you are getting??
Sat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
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.