Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher filtering by multiple KFF (account) concatenated segments.

David Wright - More4apps
Rank 3 - Community Apprentice
Description
BI Publisher allows for Where Lexical filters to be added to KFF queries (i.e. GL Accounts). However, when using Menu types only one account can be filtered. Selecting multiple accounts causes this to error.
Use Case and Business Need
Users required to report on multiple accounts cannot as BI Publisher results in an Oracle error (a SQL exception). This is not user friendly and requires each account to be searched sequentially (one by one).
Original Idea Number: 6c03fba5a1
1
Comments
-
Moved from Purchasing forum.
0