Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Sort values in Column Selector in OBIEE 11g

877006Aug 10 2012 — edited Aug 10 2012
Hello Gurus,

We have migrated from OBIEE 10g to OBIEE 11g (11.1.1.6). Have a couple of queries related to column selectors:

1. When I edit the column selector view in 11g, the columns selected in a particular column selector is not visible. As a result I am unable to edit any column properties. Why is it like this?

2. Is it possible to re-order columns of a column selector? I want to sort the values alphabetically. Is it that I have to add the values in the column selector the way I want it to appear in the drop down or is there any method through which I can sort the values after adding them to the colum selector?

Appreciate any help.

Thanks & Regards,
RG
This post has been answered by Dpka on Aug 10 2012
Jump to Answer

Comments

Dpka
Hi Rahul,
1. When I edit the column selector view in 11g, the columns selected in a particular column selector is not visible. As a result I am unable to edit any column properties. Why is it >like this?
In 11g, when you edit the column selector view in results tab you can see options to modify the column properties of each column
2. Is it possible to re-order columns of a column selector? I want to sort the values alphabetically. Is it that I have to add the values in the column selector the way I want it to >appear in the drop down or is there any method through which I can sort the values after adding them to the colum selector?
Remove the column from Column selector edit view (in results tab) by clicking on the delete icon against the column and then add the column in the order you want.

Regards,
Dpka
1 person found this helpful
877006
Hi Dpka,

Thanks for the response.

With reference to point 1, I understand that it is possible to edit column properties by editing column selector view.
However, my query is that after migration to 11g, the selected columns are not visible in the column selector editor because of which the "edit column properties" option is not visible too. And I am unbale to debug why it is so. Could you suggest a possible reason for it? Is it another bug in the tool?

With refernce to Point 2, you are confirming that there is no way to sort the values without deleting the columns. Am I right?


Thanks & Regards,
RG
Dpka
Answer
Hi Rahul,

I have faced this issue in 11.1.1.5 version. This is the bug,

Bug 12937182 : AFTER UPGRADE, COLUMN PROPERTIES ARE NOT WORKING IN COLUMN SELECTOR

Oracle syas this issue has been fixed in 11.1.1.6, looks like it still exists.

For the second query, yes there is no option to sort other than manually removing the columns.

Regards,
Dpka
Marked as Answer by 877006 · Sep 27 2020
877006
Hi Dpka,

Thanks again for the valid information.

Regards,
RG
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 7 2012
Added on Aug 10 2012
#11g, #answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #obiee, #prompt, #report, #reporting, #reports
4 comments
2,714 views