TM1 Forum

Hello

I am having many Excel structures which will be easier if there is any way to upload it as view in TM1 9.1 SP3

ABOOD wrote:Hello

I am having many Excel structures which will be easier if there is any way to upload it as view in TM1 9.1 SP3

There is no built-in feature in TM1 to do anything like this. You have three options in TM1 for building cubes: 1) Use the Perspectives (or Architect) interface, 2) Use a TI process, or 3) write an API call to do it. Options 2 and 3 are quite expensive, time-wise, so are not worth it unless creating cubes is a daily exercise in your system. That just leaves Perspectives.

You have three options in TM1 for building cubes

Not sure if that's a double mistype or not but original op was asking for a created view, not cube. There's a couple of options to do what you want - depends if you want a public or private view tbh.

You could use QUDEFINE function to build the private view (can't build a public) with a little bit of jiggery pokery or call a TI to build the view from VBA.

Had a similar query recently but apart from these two options, nobody could come up with anything else that wasn't crazy OTT.

I'm planning on creating an xla toolbar icon to create a private view of the selected cell when on a DBR/DBS function at some point in the next few weeks - it's a very simple bit of code and my time is much more free to do this kind of fun project these days so hopefully I can free up half a day to do this over the next fortnight.

I'll drop you a copy when I've built it if you like.

Regards

Hey that will be really great , will be waiting for that

Just on the off chance that the OP doesn't know, but if you have the correct references in the Excel sheet you can build the DBRWs manually (or use the formula wizrd (Alt,1,e)) to construct the references back to TM1. It wouldn't be the first time some one tried to reproduce their Excel report in a view just to slice it back into Excel again, just so they could get the DBRWs.

Cheers
Steve