on 09-30-2013 10:53 AM
Dear All,
In SAP BusinessObjects Explorer, I am getting the attached error when I choose to display a dimension 'Month' ( contains values 'January', 'February' .. , 'December') as Dimension with 'Month ( Jan to Dec)'.
The error message is as below :
------------------------------------------------------------------------------------------------------
The prompts module failed to initialize.
Server error occurred while analyzing the prompt. (PS 50201)
Details : The creation of the prompt input session failed.
------------------------------------------------------------------------------------------------------
No objects have been modified or deleted in the universe.
The current System configuration is
BI 4.0 SP6
Database: Sybase ASE 15.5
I followed the below process :
1. Go to 'Manage Spaces'
2. Select the universe
3. Select the explorer and click on 'Index Now'.
4. After indexing is successful, select 'Configure'
5. Go to the 'Objects' tab and add the dimension 'Month' from the universe as a Facet.
6. Select the facet 'Month' and under the Details section, in Dimension drop-down; select 'Months (Jan..Dec)'
7. click on Validate
Thanks and Regards,
Prathmesh
Hi All,
If I try change my source from database to Excel, this option works fine.
Only when the source is a database, this option doesnt work.
So, anyone with a solution as to why it doesnt work on a database ?
Thanks and Regards,
Prathmesh Pai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prathmesh,
This issue usually occurs when object data type is not Date at database level and that is why changing the facet to Standard resolves the issue.
Kindly refer:
http://service.sap.com/sap/support/notes/1751465
Regards,
Nakul Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nakul,
Below is the overview
Database Level : datatype is Date
Universe : extract the month and using 'case.. when' convert it to respective month names as January, February, March etc
Explorer Level : I have 2 dimensions as 'Month_Name' (derived month name form date) and 'Date' ( the date column)
The 'Date' dimension only lets me choose 'Standard' option while the others are disabled
The 'Month_Name' dimension lets me choose the 'Month ( Jan to Dec)' option but gives the error.
I hope this explains my scenario
Thanks and Regards,
Prathmesh Pai
Hi Patrick,
in your case just leave the objects as string in universe and map them to Day or Months as needed. Ignore Validation and go directly to indexing. It should index OK and the sorting should be OK after. This should work providing you don't have any prompts you need to set values for.
George
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.