TM1 Forum

Hello Everyone, I'm new to this forum.

I have been trying to use the VBA function QULOOP after successfully executing QUDEFINE. However, it appears that the QULOOP function keeps serving me up exactly the same record on each iteration of the loop I have it in. Has anyone used this function and do you have a small piece of code I can look at please.

Thank you in advance.

BTW I'm running TM1 9.5.2 with Excel 2007

Hello,

What is the goal of the exercise - what do you try to achieve ?
There are probably better ways to get there.

Hi Wim,

Basically we have 3 cubes for this application at the moment. Lets call them cube A, B and C.
Cube A has about 16 dimensions with the intersection holding a unique value known as the short-key.
Cube B holds the actually business numerical values with the first dimension being the short-key from cube A.
Cube C holds supplemental business string values with the first dimension being the short-key from cube A.
The Users use the cube viewer on cube A to obtain a list of short-key(s) to then search for information on cube B. Reports must be generated for each short key matching their searches containing the data from all 3 cubes.
I have tried using DBRWs in loops with cube B but some of the dimensions are very long and this process is far to slow.
I know TM1 is probably not the right tool for the job but that is all I have to work on.
Any suggestions would be welcomed.
Thank you.

Hello,

I would create a 4th cube for input where the user has the possibility to input (or copy/paste) the list of unique keys. Make sure that cube contains the dimension }Clients in case several people will use this cube at the same time. They should not overwrite each other's input data. Then a TI process runs (use an action button) to look up the keys and match them with the other data. Lastly, an active form presents the results based on the 4th cube.

Hi Wim,

Thanks for your very quick response.
I have never used TI, I do not believe we even have it installed. Is TI a chargeable item and if so, roughly what would it be ?
So the TI process, can read the users keys and query each of the other cubes, where does it temp. hold queried data retrieval from other cubes.
Can the active form create a rolled out report of std.format ,one for each key queried ?

Thanks again.

Hello,

Back in the days of 2007 when I started using TM1, I know that Turbo Integrator (TI) was optional.
Turbo Integrator is the ETL tool of TM1.
You can find it with "Processes" in the Server Explorer, below Applications, Cubes, Dimensions, and so on.
I am pretty sure you can use it, but still you will need to verify.
In any case, if you are new to Turbo Integrator, I advise that you read the manuals and/or follow a course / browse topics here / let someone you hire, guide you. If not it can be quite difficult and time consuming.

The TI process will loop over some sort of 'data source', it could be elements in a subset or cells in a cube view, what appears to be your case.
In general, you can also use text files or databases or Cognos packages/query's, and so on.
The variables are held in memory. You might want to create output in a 4th cube, using the TI process, on which you base the Active form.

What TM1 client do the users have to search for the values ? How do they pass the keys / cube slice of A such that you know that keys to look up in B and C ?
I was also thinking about a drill-through but that will also involve some scripting in Turbo Integrator.

Suffice to say, without any knowledge and experience in TI, this is not the easiest case to start with.