I can't load data in my cube with turbo integrator

[Federico]

Hi everyone,

it is my first post here

I have the following problem. There is a turbo integrator process, which loads data in a cube.

There are 8 cubes very similar to this, in 2 cubes the load process works perfectly, but in the other 6 cubes, no way to load any data.

Turbo integrator finish the process successfully, but when I try to get the values, I get a message "no values available".

Does anyone has a clue, where my problem might be? I have include a screenshot of a dummy loads. Very simple, but no chances.

Many thanks in advance.

P.S.: I also tried with excel, no chances too.

[Wim Gielis]

Hello

Please show us the Advanced > Data tab code.

Sorry to ask the question, but you're looking in the correct cube?

At what level do you check the data? If at consolidated level, the dimension element weightings are correct and not equal to 0 for instance?
I do suggest to check the load at the lowest level in every dimension.

Are you sure to check at the correct intersection in the cube?

[Federico]

Hi Wim,

thank you for your answer.

I'm loading data in the lowest level, I'm sure here.

I have also completely delete all data in the cube with a CubeClearData, just to be sure about the correct intersection. And created a view, which at least shows just one cell different to 0.

Following your advice about the correct intersection, I was able finally to load data in the cube for the first time.

Here, the issue, I can't explain myself.

In the dimension when I search for a leaf element, called "X123" I can find ihm.

But when I search for the same element in the cube browser, I cannot find him.

In my cube, I cannot see all the N-Elements I would like to see, and that I know, that they in the dimension.

Do you have any clue?

[Wim Gielis]

Hello

Be careful with searching for elements...

If you search by wildcard (* and ?), you only search in the current alias (or element name if no alias chosen).
You also only search in the elements that are shown on screen. The search function will not look for a match in all other (hidden) elements.
I guess that this is your problem.

If you do not search by wildcards, the same rules apply. But in that case, it's by far the easiest to type the name of element in Excel or Notepad, copy/paste in the Subset Editor. That way you're sure to find it (and if it does not exist, you will get a message telling so).

In a cubeview, you should work with predefined subsets, or, if you don't, make sure you hit the "Show ALL" button in the topleft corner of the Subset Editor (the very first icon in fact).

Wim

[Federico]

Thanks Wim,

a colleague of mine created another view. I don't really know how, if with subset.

But the funny thing is, the data was there. It was correctly loaded.

I think, I have to read the books again

Have a nice day,
Federico

[Wim Gielis]

I think, I have to read the books again

Definitely, because views and subsets and navigating in the cube are rather basic tasks in TM1