on 03-07-2018 3:13 PM
Hi All,
We are running Copy package in the starting of every month. After running successfully Copy package we are trying to run some reports to check if data is copied correctly or not. But when we do this data is not reflecting in report. So we have checked backend database tables and inside table (i.e. tblfactWBFinance,tblfac2Finance) data is present for copied category and time period.
kindly help us here to finding out root cause for the same.
Hi Swati,
are you using a standard copy package or a custom? In this case verify that you are writing on the factwb table or that you are doing an optimize after the copy. The Analysis Services need an optimize to update the nodes values on data written directly in fact2 or fact table only values on fatcwb are updated dinamically.
Kind regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Roberto,
Thanks for reply!
We are using standard COPY package to copy data. But challenge is every time we need to run ADMIN OPTIMIZE and its not acceptable by business. We are looking for some solution so that without running ADMIN OPTIMIZE value should reflect in reports. Currently data is present in fac2 and factwb tables but its not coming in the report.
User | Count |
---|---|
12 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.