Focal Point
Measure loader problem/limitation with filters

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/1591082782

June 10, 2008, 09:40 AM
Trav
Measure loader problem/limitation with filters
I ran into a sort of strange problem today while loading a measure that had a filter on it. I could apply the filter, preview it and it would look fine -- but when I hit the "load" button, it wouldn't work. No error, no message that the load completed, nothing.

I also noticed on these same measures that each time I went back into the measure loader screen, part of the filter value had been truncated. I finally realized that it was cutting off the filter value after 25 characters and that was what was causing my loading problems also.

A couple of questions on this:


Obviously, I can log a case on this if you think that's the best course of action -- just wanted to pose it here first since the behavior was a little odd.



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
June 10, 2008, 05:46 PM
Michael Paul
Hi Trav,

Thanks for notifying us of this limitation. This has been changed in PMF for version 421 going forward. You will now be able to input 254 characters in the value field.

As an alternate workaround you could change the "Source" drop down to "Code" and in the Edit text you can reference columns in the measures master file and the length of this can be extremely large (1024A). Just use the syntax "WHERE FIELD_NAME EQ 'FIELD_VALUE'" in the Edit field. I would probably recommend this when the field value becomes very large as you can view the entire contents better.

Let me know if this helps.
Mike