on 07-08-2013 12:01 PM
Dear Experts,
This is w.r.t deletion of request for the month (MAY 2013)happened accidentally at Cube level as load is monthly once, we can't able to find the solution how to restore the deleted request .
we gone some probabilities to reload from APD query source as it is full update is going , discrepancy of load may happen from month by month
Flow follows like ->
APD Query -> Direct Update DSO-> Further update CUBE -> Request Deleted.
Kindly provide inputs on this.
Thanks®ards,
Singam
Hi,
we gone some probabilities to reload from APD query source as it is full update is going , discrepancy of load may happen from month by month
What is full update? It is not clear. If May month request deleted, then subsequent months data will also be not useful...? What is your doubt actually?
Can you make your query to run for month of may again? You can hardcode the may month in your query. So, when your APD executes, it will load May month data and move across to cube. After this, revert your query to back status.
Regards,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From where do you load your requests?
Please explain more the dataflow of your model.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Can you explain why you can not reuse the APD query ?
Isn't there any time restrictions you can use ?
PY
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.