Creating cubes and dimensions in Excel

[viswaraju]

hi,
please can help me out for getting the pdfs or links for creating dimensions and cubes with excel in TM1
I had developed the dimesions in excel with Xdi, no idea on creating cube.

Thanks and regards

[tomok]

There is no Excel interface for creating cubes. Only dimensions and rules. You would have to write your own with the API.

[David Usherwood]

Or you could....
Open Perspectives
Navigate to the Cubes heading
Right-click
and create the cube??

[viswaraju]

thank you very much

[viswaraju]

Dear David,
I am trying it but i am not succeeding, please can you give me hints or procedure for creating dimensions, cubes and rules with excel in TM1.

Thanks and regards.

[Alan Kirk]

Dear David,
I am trying it but i am not succeeding, please can you give me hints or procedure for creating dimensions, cubes and rules with excel in TM1.

Creating dimensions via .xdis:
Here, and more specifically, here.

Creating rules via .xrus:
Here.

Creating Cubes via Excel/Server Explorer:
Step by step instructions, here.

[tomok]

Creating Cubes via Excel/Server Explorer:
Step by step instructions, here.

With all due respect. Server Exporer, aka, Perspectives. is not Excel. The XDI and XRU Excel-based sheets are Excel. There is no equivalent for cubes. Of course you already knew that.

[lotsaram]

I think it's an absurd thing to have a disagreement over but Perspectives is an Add-In to Excel. It is after all accessed via Excel. I would have answered this question in exactly the same way as David. (Why the original poster didn't have the gumption to figure this out for themselves or maybe read the developers' guide is of course another matter.)

[Alan Kirk]

Creating Cubes via Excel/Server Explorer:
Step by step instructions, here.

With all due respect. Server Exporer, aka, Perspectives. is not Excel. The XDI and XRU Excel-based sheets are Excel. There is no equivalent for cubes. Of course you already knew that.

Yup. Try running Server Explorer without Excel some time. Let me know how that works for ya. And if we're going to play in pedantry corner, it would follow that Architect @<> Server Explorer and Web @<> Server Explorer.

Or, alternatively, any non-modal form launched from an .xla @<> Excel.

Put another way, "what Lotsaram just said".

[tomok]

The Server Explorer viewer, as launched through Excel, AKA, Perspectives, is nothing more than Architect. It is not an Excel interface. The options the OP was talking about were Excel sheets, in conjunction with menu options added to Excel used to maintain dimensions. There is no equivalent for maintaining cubes. That's my point. Using the Server Explorer to right click on the Cubes object and choosing Create New Cube is not Excel, at least in my opinion and I'm pretty sure it's not what the OP was asking about.

[Alan Kirk]

The Server Explorer viewer, as launched through Excel, AKA, Perspectives, is nothing more than Architect.

Is it indeed? Perhaps you'd care to explain how those who don't install the Architect .exe (which, incidentally, was not part of the standard install last time I checked) are able to use Perspectives at all.

It's probably built on the same code base. That doesn't mean it's the same thing. Not that that's relevant to the point at hand.

It is not an Excel interface.

Yeah, if you say so. As I said, if it's nit-picking pedantry time then neither is any other non-modal form launched from Excel.

The options the OP was talking about were Excel sheets, in conjunction with menu options added to Excel used to maintain dimensions. There is no equivalent for maintaining cubes.

You've added telepathy to your list of skills?

He said "for creating dimensions and cubes with excel in TM1". Yes, he did mention .xdis in the following paragraph. It doesn't automatically follow that he was referring only to creating the things via spreadsheets. And even if he was, a useful reply would have been that it can't be done through spreadsheets but can be done by {insert the contents of David's post}.

That's my point. Using the Server Explorer to right click on the Cubes object and choosing Create New Cube is not Excel, at least in my opinion and I'm pretty sure it's not what the OP was asking about.

The essence of the question was "I have Excel with TM1 loaded, how do I create a cube?" And the short answer to that is that while you can't do it through a worksheet, there is a way which does NOT involve writing your own API which, it could be argued, is not Excel either.

[Christopher Kernahan]

Anyone considered that the OP is a double-agent from SAP sent to turn everyone on the forum against each other?