Questions on Excel-Sheets for TM1Web

[schlemiel29]

I try to build a report with more than one dynamic row dimension. With 13 dimensions in a cube I use one for period as column headers, 11 are fixed in the header and two schould be dynamically for the row heads.
If I create this report within the Cube Viewer, do a cut (I don't know the engl. words. bc. I'm using the german version) and get an excel sheet. If I publish it, it works fine. But where are the informations stored, defining this view? I've found something like this in the first two cells:
A1 A2
CUBE: =VIEW("modell:MyCube";$B$2;$B$3;$B$4;"!";$B$5;$B$6;$B$7;$B$8;$B$9;$B$10;$B$11;"!";"!")

Ok, "!" indicating a non fixed dimenesion, but where is the hint if it is in a column or row? Is it the first or second dimension in the row header? Where is "zero suppression" stored?

I want to make the report more convenient and optimize the look and feel. After that, I don't want to start at the very beginning if I have to change something basically.

How the rows are created? Where is the definition if all elements of the dim are used or only a subset?

I didn't find these answers in the TM1 Developer Guide nor in the User Guide. Did I miss something or is there any additional documentation? Thanks a lot in advance!
Dirk

[tomok]

The questions you are asking are only applicable to Active Form reports. From what I've seen you have simply "sliced" a view to Excel which DOES NOT create an active form. There is a different icon in the Cube Viewer for creating an Active Form report. Give that one a try.

[schlemiel29]

Yes, thank you. That's it.

[AmbPin]

Yo may have fugured this out, but if you do create an Active form then the elements that are included are often defined in a hidden worksheet within your workbook.

[schlemiel29]

Yes, I found these hidden sheets for every dimension. Thanx!

[lotsaram]

Yes, I found these hidden sheets for every dimension. Thanx!

Having the dimension rowsets defined in the hidden Excel sheets is the most inefficient way of building an active form in terms of performance. You are much better off to either reference a named public subset or generate the rowsets via MDX.

[schlemiel29]

Yes, I'm on the way!
I found the hidden lists and replaced them by static subsets.
But unfortunatly I don't understand to use MDX to filter rows.
Depending on a setting of a combobox, I want to hide some rows.
How would an MDX look like, if the task is like that:
IF SelectionOfCBO like $B13 THEN show ELSE hide

$B13 should be the first row of the data block below the titles. So all rows should depend on the evaluation of column B.