TM1 Forum

Hello all,

I'm currently losing my mind on a strange problem, which occurs on my perspective.
This is very simple :
- I work on a cube
- I want to export and create a excel doc which i can transform for my users.
=> this step works very well, i retrieve my table with all the basic stuff : Tm1rptview, tm1rptrow, dbrw, named cells, hidden sheets, format, ...
I can refresh and work on my data on it, it's OK.


BUT

If i want to change some things on it (at first, i just want to add a MDX on my two tm1rptrow), nothing change, the previous list is kept (By exemple, the original table has 3 sites and 50 customers, i retrieve all of them !)
=> I change the MDX. list is retrieved on refresh
=> I suppress one hidden sheet (!). List is kept on refresh
=> I delete one and the two tm1rptrow (!!). List is kept on refresh
=> I SELECT ALL THE ROWS/COLUMN ON MY SHEET, SUPPRESS THE WHOLE THINGS, DELETE THE 2 HIDDEN SHEETS, DELETE THE NAMED CELLS, THEN I HAVE ONE SINGLE WHITE SHEET..... I retrieve the 50 customers on F9
What the hell append?
Service has restarted this night, the problem still occurs. My co-worker has the same problem on his computer. We are connected on citrix.
Version is 10.1.1 on Excel 2004
I show this to the two TM1 expert supplier and they have never seen that.

Is someone can help me on this?

Thanks in advance.
Regards,
Adrien.

I may be having a slow day but I'm struggling to decipher the problem.

A couple of things that did stand out from your post:
1/ You don't want hidden sheets in an active form (with the exception of picklist ones) the AR sheets are a huge performance killer - if you had them and delete them you need to remove the reference to them in the rptrow formula or it will fail... you need to replace with a subset or mdx statement etc. I would always try and do this immediately after creating the form or export a cube view with named subsets so that you never get AR sheets.
2/ You stated you are on excel 2004... I assume this was a typo; are you on 2003?
3/ Also you say refresh the sheet a lot; remember with active forms you need to rebuild instead of refresh.

Hi Declanr,

Thanks for your reply.
The problem is very simple in fact.
When i make an active form from a cube, i can change everything on my sheet (including modify tm1rptrow, delete dbrw, delete tm1rptview, delete everything) => on rebuild, i retrieve all the dimension elements i had on my initial view (even if tm1rptrow/view are deleted !!!)

1/ i know that, i usually use MDX and delete the hidden sheets. By default, active form created from a cube view create this, i talk about hidden sheet for my strange example.
2/ 2003 indeed
3/ got it ! I usually talk about refresh instead of rebuild. I'm gonna remeber this.

Regards,
Adrien

Upload the sheet so we can take a look. Off the top of my head I would say your TM1RPTROW formula is not correct so the active form is reverting back to the initial range in the hidden tab. This is pretty common.