APAR status
Closed as unreproducible.
Error description
Customer wants more dynamic functionality that will achieve similar filtering as the Filter by View Extract functionality when you open the subset editor from a Cube View.. For example, customer would like to be able to create a dynamic subset (based on an MDX Expression that evaluates/filters based on cell values within a view). Heres an example: 1) Prep - before starting the Planning Sample, copy the attached file (mb-FilterByExtract.vue) into the plan_BudgetPlan}vues folder 2) Startup Planning Sample TM1 Server. 3) Open the plan_BudgetPlan -> mb-FilterByExtract view. 4) Double click on plan_business_unit to open the subset editor for this dimension. From the Subset Editor, bring up the Expression Window and paste the following into the expression window: filter( [plan_business_unit].members, [plan_BudgetPlan].[plan_time].[Jan-2004] > 400000 ) then click update. This SHOULD display/select the 3 members that meet this criteria (in this example, Germany, US, ROW), but instead, removes all elements from the dynamic subset were trying to build (not sure why it doesnt keep those 3 elements). Also, when you try to save this subset (with the Save Expression option checked), you get an error: A subset containing no elements cannot be saved. Our subset editor will not let you save a subset definition when there are 0 elements, even if the subset is dynamic. When the subset editor is running, theres no cube context set, and so the filtering takes place with the default members in context for those dimensions that arent referred to in the expression, which is why 0 elements are resulting then the subset editor indicates we cannot save that dynamic subset. Also, creating a process using the Cube View as a data source, and using the SubsetCreateByMDX function along with the MDX Expression above to see if this was possible by another method. This is also unsuccessful - the TI Process results in an error Could not create dynamic subset.
Local fix
1) Create a dynamic subset on the appropriate dimenstion (and ju st use the default expression {TM1SUBSETBASIS()} 2) stop the TM1 Server 3) find the subset on the file system 4) use a text edit or to plug in the expression (replace the default expression {TM 1SUBSETBASIS()} with the MDX expression you want to use, for exa mple: filter( [plan_business_unit].members, [plan_BudgetPlan].[p lan_time].[Jan-2004] > 400000 ) 4) Restart the TM1 Server 5) Ap ply the Dynamic Subset to the view, and it works!
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Please upgrade to IBM Cognos TM1 10.2 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PM32214
Reported component name
TM1 SERVER
Reported component ID
5724W49SE
Reported release
951
Status
CLOSED UR3
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-02-08
Closed date
2013-09-12
Last modified date
2013-09-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TM1 SERVER
Fixed component ID
5724W49SE
Applicable component levels
RA20 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 September 2021