Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [CLOSED]Excluding dimension values (IE. LOCATION NE 'Location Name') and multi-select

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Excluding dimension values (IE. LOCATION NE 'Location Name') and multi-select
 Login/Join
 
Guru
posted
Hi Team,

I've got some Measures in PMF that have some Dimensions associated to them, and this has worked fairly well for my users for about a year. In fact, this has worked so well that they have grown to understand that they need to consume these measures in ways that were never imagined in the past. There are two fundamental changes that they want, both of which are related:

-the ability to multi-select dimension values
-the ability to exclude or include dimension values (multi-selectable, of course!)

At first glance, these two items do not seem to play well with PMF. However, I am a believer in framework applications versus custom coding. I have the first glimmerings of an idea about how to accomplish this using the dimensional model within PMF:

-multi-select could be accomplished by defining a parent dimension value that contains the desired child values. The downside is that this is not very flexible, as it would require dimension changes every time the grouping requirements were modified. Still, it's one possible path
-the ability to exclude dimension values is tricky. I am thinking about a flag based key system, but my concern is that I might end up inflating my record count if I have to store every combination (EG. These numbers exclude these values, these other numbers include these but exclude those). I still don't see this part clearly, but I am trying to work through it conceptually

I am writing this post because I wonder if I'm missing something very obvious? As far as I know, PMF does not do multi-select on dimension values and it only allows EQUAL TO filters, not NOT EQUAL TO filters, correct? If this is so, as I think it is, what do you think about my admittedly hazy ideas about how to shoehorn this functionality into the system?

Cheers,

Joey

This message has been edited. Last edited by: Moogle,


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Master
posted Hide Post
Multi-select is on the feature list for the 5.3 track. It will probably not be in 5.3.0 but it will show up during the 5.3 release progression.

Very complex boolean operations are largely a niche interest. For this we recommend a custom report or gadget against the PMF data. You can get most of what you want using Dimensional intersections. Right now you CAN do (Product = Toasters) AND (Location = Chicago) AND (Year = 2011). With multi-select you'll be able to do (Product = (Toasters OR Microwaves)) AND (Location = (Chicago OR Detroit)) AND (Year = 2011)

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [CLOSED]Excluding dimension values (IE. LOCATION NE 'Location Name') and multi-select

Copyright © 1996-2020 Information Builders