limits to load dimensional elements through Excel

[monishapm]

Hi,

I am loading dimensional elements through excel. Total 690 elements are there. I am not able to load the elements from line 376.

Pls tell me a soln to load entire elements through excel .


Regards,

Monisha.

[Alan Kirk]

Hi,

I am loading dimensional elements through excel. Total 690 elements are there. I am not able to load the elements from line 376.

Pls tell me a soln to load entire elements through excel .

What do you mean you're "trying to load ... through Excel"? Are you using an .xdi? Are you using the DF_Save macro function? As per the Request for Assistance Guidelines:

if you're getting unexpected results, specifics of what you're running, how, and what results you're getting will yield a more valuable response than "I'm running a T.I. but my code doesn't work properly".

In this case it probably wouldn't be a bad idea to post a copy of the source data, particularly the parts from line 370 or so on.

Admin Note: This thread has been moved to the correct forum from General.

[monishapm]

Hi,


I am using TM1 Excel perspective. In Excel perspective I tried to create dimension. That dimension had 670 elements + Consolidations in it. Its Showing error, " Error in creating line 376<"","","">

I thought there is some syntax error in my consolidation , but when i removed the elements till 376 and added the elements from 376 to 576. It was getting added.


Regards

Monisha.

[Alan Kirk]

I am using TM1 Excel perspective. In Excel perspective I tried to create dimension. That dimension had 670 elements + Consolidations in it. Its Showing error, " Error in creating line 376<"","","">

I thought there is some syntax error in my consolidation , but when i removed the elements till 376 and added the elements from 376 to 576. It was getting added.

And I repeat. HOW in "Excel Perspectives" (which is the entire add-in, not a dimension creating tool) were you attempting to achieve this feat? By which method? Using which commands? In which part of the interface? HOW are you trying to do this?

And incidentally, that error message sounds much more like TI than anything that comes out of Perspectives.

[monishapm]

Hi,
I tried to attach the screenshot of my excel perspective but i am not able to.

I am using TM1 9.5. In the excel perspective there is a tab called devoloper. In that Dimension create , Dmesion Open and Dimension Save options are there. When we use Dimension create option an excel sheet named *.xdi gets opened. In that i wrote following heirachy.

N: a
N: b
.
.
.
C: Ab
a
b

Like this..

But at certain point its showing that it cant insert Ab,"","".

Regards

Monisha

[Alan Kirk]

Hi,
I tried to attach the screenshot of my excel perspective but i am not able to.

(1) [Alt]+[Print Screen]
(2) Windows Start menu -> Programs -> Accessories -> Paint
(3) [Ctrl]+[V] to paste the capture into Paint
(4) File menu -> Save As, changing the file type to a .jpg
(5) On the Upload Attachment tab below the main message window, click the [Browse] button to select the jpg file that you just created, then click the [Add The File] button.

I am using TM1 9.5. In the excel perspective there is a tab called devoloper. In that Dimension create , Dmesion Open and Dimension Save options are there.

You're certain that this isn't a toolbar, not a tab, named TM1 Developer?

When we use Dimension create option an excel sheet named *.xdi gets opened.

OK, so you're doing this through an .xdi, now we're getting somewhere.

In that i wrote following heirachy.

N: a
N: b
.
.
.
C: Ab
a
b

Like this..

But at certain point its showing that it cant insert Ab,"","".

Which is not at all the same error message as you reported previously. Nonetheless, generically speaking, with an .xdi you'll get a "can't insert" error message where one or more of the elements that you have under the consolidation has not been defined as an N level element. For example, if you have:

Code: Select all

N     a
N     b

C     ab
       a
       e

You'll get an error message indicating that e can't be inserted, because e does not in fact exist in the dimension.

A more difficult to detect error is if you have, for example, two single quotes in front of one of the elements under the consolidation. One single quote will identify the child element as a string. Two together will cause the second quote mark to be interpreted as part of the element name. There could be any number of other formatting issues which will cause this, but the short of it is that you're probably trying to insert a non-existent element into a consolidation at that point, although if an .xdi fails to save it fails all the way. It won't do a partial addition of the elements.

[monishapm]

Hi,

Its working now. Thanks to all.
In the formula bar the value of the cell was coming truncated.

For eg: If the cell had "frozen & fresh food", in the formula bar it was showing only "Frozen &". I removed all these kind of cells and retyped. It got corrected then.

Once again thanks..

regards

monisha.