Cafe Question...

[donap]

All -
Cafe Question --
We have a hierarchy similar to  CITIES below.
For buisiness purposes, the hierarchy is set up as shown, with the  EAST , MID, WEST regions set up as Alternate hierarchies.
Using the user who only has access to CHICAGO,  scroll down to see our dilemma -- If we grant access to the Parents,
in CAFE, the user still sees the TOTAL Dollars - not just Chicago Dollars. 
If we do not grant access to the Parent, only the Child,  Chicago appears TWICE in the Cafe Tree  -- but without the parent, it is very confusing

Any suggestions ?


                    YTD Dollars
ALL_CITIES   $950,654.00
     Boston    $2,503.00
     Chicago   $60,000.00
     Dallas      $3,490.00
     Hartford   $88,888.00
     Houston   $4,590.00
     Kansas City   $203,404.00
     Los Angeles   $45,809.00
     Minnesota    $234,235.00
     New York   $98,092.00
     Philadelphia   $454.00
     Portland   $24,436.00
     San Jose   $78,568.00
     Seattle           $49,649.00
     Washington, DC   $56,536.00
  East Cities   $246,473.00
     Boston    $2,503.00
     Hartford   $88,888.00
     New York   $98,092.00
     Philadelphia   $454.00
     Washington, DC   $56,536.00
  Mid- Cities   $505,719.00
     Chicago   $60,000.00
     Dallas    $3,490.00
     Minnesota    $234,235.00
     Houston   $4,590.00
     Kansas City   $203,404.00
   West- Cities   $198,462.00
     Los Angeles   $45,809.00
      Portland   $24,436.00
      San Jose   $78,568.00
      Seattle   $49,649.00


CURRENT User with access only to Chicago         
                    YTD Dollars
ALL_CITIES   $950,654.00
     Chicago   $60,000.00
   Mid- Cities   $505,719.00
     Chicago   $60,000.00
   
   
   

DESIRED RESULT User with access only to Chicago         
                    YTD Dollars
ALL_CITIES   $60,000.00
     Chicago   $60,000.00
   Mid- Cities   $60,000.00
     Chicago   $60,000.00

[AJAYC]

Hi Donap

I don't think that this is an issue with CAFE, but more the way security works in TM1.

If you grant access to the parent, you'll see the parent value, and similarly, if you grant to the child you will see the multiple child elements, as you are experiencing.

You may wish to think of an alternate way of getting this to work.

How about you create a city based hierarchy with a pseudo consolidation element (weighted 1) which consolidates into the parent, and then have the others consolidate with a weighting of zero. Then have a rule which populates the new pseudo parent, with the sum of the other children. You can then provide READ access to the parent but hide NONE to the pseudo.

For example, set the hierarchy like this:

(C) East Cities
(N) --East Cities_Rollup (1)
(N) --Boston                 (0)
(N) --Hartford               (0)
(N) --New York             (0)
(N) --Philadelphia          (0)
(N) --Washington, DC   (0)


Then put in a rule for "East Cities_Rollup" which simply adds "Boston" down to "Washington"

(C) East Cities                 $246,473.00
(N) --East Cities_Rollup   $246,473.00
(N) --Boston                      $2,503.00
(N) --Hartford                  $88,888.00
(N) --New York                $98,092.00
(N) --Philadelphia                $454.00
(N) --Washington, DC      $56,536.00


Provide the security to the user to see only "Boston" and "East Cities" and you should get the following, for the user:

(C) East Cities                       $2,503.00
(N) --Boston                         $2,503.00


Obviously this is just a skeleton of an idea, but please let us know how you get on, as others will find this useful.

Cheers
Ajay