TM1 Forum

First, apologies for the title - i couldn't dilute the explanation of the problem suitably.

9.4.1 FP3, 2003 Server x64. Excel 2003.

I have two active forms. The first is a summary form that has 3 title dimension as subnm's and a single TM1RPTROW dimension, plus a column dim for the measures. I'll call this summary1
The second is a leaf level representation with three title dimensions and a single TM1RPTROW dimension, and the same column dim for measures. I'll call this Detail1. This acts as the drill down detail and the only difference is that two of the dimensions are swapped. The row dimension in Summary1 is a title dimension in Detail1 and the third title dim in Summary 1 is the row dim in Detail1.

I have a simple action button on Summary1 that navigates between the two separate excel files, which has a single 'Selected DBRW' statement under the advanced options as follows:

Source Type: Selected DBRW
SourceObject: Account
Target Type: SUBNM
Target Object: Account
Subset: Planning
Alias: Name

Now, under Excel, all is well and good - the button works perfectly - and drills across to the Detail1 book and restricts the title dimension to the correct intersection cell (DBRW) selected on the Summary1 book.

In Web, it simply defaults to first element in the Account title dimension, regardless.

Anyone seen this issue?
Craig

An update.

It appears that Excel will allow a drill to zero/sparse intersections using this functionality, whereas TM1Web requires a detail value that is not zero.

Not much use when designing a planning app where the detail entry drives the summary!

Any thoughts still appreciated...