spool a tm1 subset to Excel

[dan.kelleher]

Does anyone know how to spool a tm1 subset to Excel along with the attributes belonging to that subset?

I cannot use activeforms for the task in mind, instead having to manipulate a slice using VBA.

I couldn't seem to find a worksheet function (or method in VBA) that allows you to do the above.

Any ideas would be most helpful.

Thanks,

Dan

[Steve Rowe]

HI Dan,

You should be able to use subnm to step through a subset by advancing the index (using row() if you are in an excel spreadsheet). To bring back the attribute use DBRA.

HTH

[LoadzaGrunt]

SUBPICK might help

[lotsaram]

I'm not sure what you mean by "spool" in this context but Steve's suggestion of using SUBNM with an index argument will allow you to list out all subset members.

Incidentally why couldn't you use an active form? You can edit and add to formulas in an active form much as you can in any slice ...

[dan.kelleher]

I want to dynamically decide what account in my CoA dimension I need to post to depending on the project:

Table (derived from TM1 subset):
Project Type Attribute
Project1 External
Project2 Internal
... ...

Slice:

Project CoA Data
Project1 Sales External 10.3

The project dimension should have subsets for each organisation, and I want to be able to create the table using VBA or worksheet functions. I don't think this can be done in an active form, as placing the 2 dimensions on the vertical axis will repeat each CoA element for each project, of which only 1 is applicable.

Any help greatly appreciated.

Dan

[Steve Rowe]

Dan,
If it's 1:1 project to CoA it's pretty straight foward.
You can list the project subset using subNm with a row() based index.
You'll need to create an attribute on the project dim that holds the relevant CoA for the project code.
Use the DBRA function to retrieve the attribute in the spredsheet.

HTH