cancel
Showing results for 
Search instead for 
Did you mean: 

Error while configuring Facet dimension as a Month (Jan..Dec)

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

I found a workarround for this.  I don't know if it's the same pattern as you.

When you configure your dimension as "Month(Jan...Dec)", then it validate, it give you error.  Just don't validate , save only rather.  Then index, it work for me.


Former Member
0 Kudos

Hi Delage,

You are right

I rememebred that we raised one OSS to SAP on this issue

Just index without validate

Best regards

Alex yang

Former Member
0 Kudos

Hi Patrick,

This worked.

Many Thanks !!

Thanks and Regards,

Prathmesh Pai

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Dear Nakul,

Thank you for the reply !!

The note mentions to fix the error by changing to standard.

In my case, i do not wish to use 'Standard' option as it sorts my months alphabetically in the explorer.

Hence, I wish to use the 'Month ( Jan to Dec)' option.

Thanks and Regards,

Prathmesh Pai

Former Member
0 Kudos

Hi Prathmesh,

Kindly verify the data type of this object at the DB level, if it is not date type then change it accordingly and then test the issue without using standard.

Regards,

Nakul Mehta

Former Member
0 Kudos

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


Former Member
0 Kudos

I have the same issue.  My column is string but it's the audit database which come with BO.  But, I see everything with BO world...

I also try a date, the option is grayout.


Do you have any fix yet ?

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

Change facet to Standard in Explorer.

Sandeep

Former Member
0 Kudos

Dear Sandeep,

Thank you for the reply.

I am aware it works when the facet is changed to  'Standard'.

The question is why the error when its changed to 'Month ( Jan to Dec)'.

Thanks and Regards,

Prathmesh

Former Member
0 Kudos

Hi

     The facet changed from Standard to Month may be set as some other type like Char type at database level. Please check that.

Sandeep