on 02-06-2015 4:26 PM
Hi,
I created a BPC model in excel which contains 40 tabs using the formula =EPMRetrieveData. When I tried to refresh the whole workbook I got all error messages in each cell containing (#RFR). Did anyone encounter the same issue when you had multiple tabs in a workbook? If so, are there any recommendation I can use to have the workbook refresh all the sheets at once instead of hitting refresh on each individual worksheet? Thanks in advance for your help and inputs!!
Hello Elaseri,
Have you resolved this issue..I believe we may have the same issue. We are on BPC 10.1 sp24
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Elaseri,
Is there any specific requirement to create 40 tabs (sheet) in single workbook ?
What is the reason to use EPMRetrieveData ?
Definitely it's not best practice. Create report using report editor.
Explain your requirement.
Is it working by refreshing two times ?
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Elaseri,
probably the error is related with epmscaledata that doesn't refresh, see please 1738468 - EPMScaleData is not refreshed and upgrade your sp.
Regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
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.