PM32214: CANT SAVE DYNAMIC SUBSETS THAT GO TO 0 ELEMENTS

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 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