Data value retains in web-sheets

[manoj928]

Hello ALL,

I am facing a weird issue, if you all gurus can help me in getting rid of that.

In our application we have developed a screens flow in TM1 web using HTML pages and web-sheet pages. Now what we did, in a HTML page, a link redirects a user to a web-sheet where we have list as data pull from TM1, and next to each record, we have a link in web-sheet, which takes user to another web-sheet which is again a web-sheet with Form kind of look. In this web-sheet, we have few drop downs, in cells aligned and designed properly.

Now the problem is , for first record, all these flow works fine, but if user goes to any next record, the last web-sheet shows the same data form values in cell which we had for previous record. We want to reset all to default in web-sheet, which must be as per TM1, but it is not doing like that.

So let me know if any setting we will have to do in TM1 config to get rid of this issue.

Thanks in adv,
Manoj

[declanr]

I'm not 100% on exactly what you are doing but it sounds like you have an active form where the tm1rptview formula doesn't cover all the bases....

[manoj928]

It is an excel drop down list. I think this is the reason for issue as excel retains the value between two records.

Please confirm.

[declanr]

It is an excel drop down list. I think this is the reason for issue as excel retains the value between two records.

Please confirm.

Can you post some screen shots to clarify what the issue is?

Re-reading it I think you possibly have 2 websheets and in both of them have a title dimension of lets say "Department".
You want a user to select a department in 1 and then have that same department show in the second?

There are ways you can do this such as removing the tabs at the top of tm1 web and having users only navigate between sheets by using navigation buttons (action buttons) within the sheets that send across the title elements and various other things that may or may not be needed whilst opening the second page.
However another way around it would be to have the drop down list where you choose the department actually being within a 2d control cube. One dimension is the }clients dim and the other is a control cell that has a picklist of all dims. That way when you select it in one, the second will also pick it up via a DBRW (albeit needing a recalc if the second page was already open.)

And I may have been entirely off track on what the actual issue is there.

[Andy Key]

That way when you select it in one, the second will also pick it up via a DBRW (albeit needing a recalc if the second page was already open.)

If you are using the 2d cube approach (which I do myself, as I find the passing of title elements via action button is, er, inconsistent) then use a DBR to that cube rather than a DBRW so that these values are retrieved from the 2d cube before the data area of the report that is depending on them.

Using this approach you can also replicate the functionality of the purely Excel based drop downs with a TM1 derived PickList on the Measure dimension of the 2d cube, meaning that you can maintain it all in TM1 rather than having to revisit the Excel sheets when you need to add an item in the drop down.