Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, June 7, 2017

Smartview Ad hoc grid cannot be opened as there are no valid rows of data


In smarview when trying to do the ad-hoc analysis you may see the below error message:

Ad hoc grid cannot be opened as there are no valid rows of data
















Fix:

Under Data Options:
you should clear the suppress options in the Data Options tab of the Options dialog box. Ensure that all Suppress Rows and Suppress Columns options are cleared, and that the Suppress missing blocks option is cleared



Tuesday, May 16, 2017

EPMLCM-13000: Service currently not available.


While importing artifacts using LCM you may run into the below error:

Error:
EPMLCM-13000: Service currently not available.


Issue:
This issue is caused by unpublished Bug 18327819 - LCM IMPORT FAILS WITH "MAX ERRORS THRESHOLD" SET AS "<=100" IN MIGRATION OPTIONS



SOLUTION:
1. Login to Shared Services Console with administrator user.
2. Change the value of "Shared Services - Max Errors Threshold" under Administration->Migration Options to "5000".
3. Attempt to Import or Export artifacts again.





Friday, May 12, 2017

Cannot open file: [\Middleware\user_projects\epmsystem1\tmp\tempfile46694208.txt] Unexpected Essbase error 1030100


Issue:

Cannot Open/load data when Importing Data Using the Essbase Administration Services Console (EAS)

 Unexpected Essbase Error 1030100







Fix:
Rename the data file to .txt extension and then try again

An Unpublished Enhancement Request has been filed to support files with any extension: Bug 23537231