Trying to use filtering by map cells MAX VALUE

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

Trying to use filtering by map cells MAX VALUE

Postby dophin » Thu Dec 20, 2007 5:30 pm

Hello, Alex

I'm trying to use filtering by map cells setting a value on Max Value field
after checking the "enabled" checkbox

It does not seem to work

The other case, i.e. setting a value on Min Value field, works fine

Could you please help me ?

Best regards,

Joseph Osende
dophin
Developer
 
Posts: 33
Joined: Fri Jun 15, 2007 12:35 am

Postby AlexZencovich » Fri Dec 21, 2007 9:12 pm

It works. You just need set Max value less than value you want to filter out.

Like in demo we provide, do the next

1. Build cube in standard mode. It will have Year,season by rows, Ware on columns
2. Open measure editor for SummaDN measure
3. set MaxValue (by map cells) to 100,000
4. Click OK

You will see only 2 rows - 2002,2006 year. All items, larger than 100,000 will filtered out
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Postby dophin » Sat Dec 22, 2007 1:36 pm

Thank you for the reply, Alex

Does this mean that I MUST AND CAN use a cube ONLY in STANDARD mode if I want to make some filtering by map cells using MaxValue ?

Using your tool, with a supersaturated cube the minvalue filter
works fine, on a measure added at runtime. I'm really missing
something.

Could you tell me a possible error that i've made ?

best regards,

Joseph Osende
dophin
Developer
 
Posts: 33
Joined: Fri Jun 15, 2007 12:35 am

Postby AlexZencovich » Sat Dec 22, 2007 2:29 pm

In extended mode it works in same way. In standard mode you cannot use filters by fact table records (corresponding controls disabled)

I do not know which errors you made because I do not know what you did. May be you enter value which do not change presented grid values so you think it does not work. Please note - if some cells filtered out but some still it may not change number of rows/columns until not all cells in row/column filtered out
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 1 guest

cron