TM1 Forum

Hello

I have one simple question. I have a table in Active Form and I would like to know if it is possible to have second row with other variable than first. I use function DBRW. First parametr is a cube, second is the same like in every row, but the last one is dynamic and is taken according to apropriate line. I would like to have two dynamic parameters in one DBRW function but, it doesn't work in tm1 application. It is possible?

Please ask if you don't understand issue.

	2013	2014
E1	DBRW( cube, E1,P1,2013)	DBRW(cube, E1, P1, 2014)
E2	DBRW( cube, E2,P2,2013)	DBRW(cube, E2, P2, 2014)

where:
E1, E2 - elements of dimension 1
P1, P2 - elements of dimension 2
2013, 2014 - elements of dimension 3
All elements are described as reference to cells.

When I recalculate form it looks like this:

	2013	2014
E1	NumValue	NumValue
E2

In spite of fact, that all data is provided in cube, the second row is empty. Does anybody know why?

If it doesn't work, which I assume means you are getting KEY_ERR messages, then you have to make sure that every reference in every DBRW generated points to a real element in the appropriate dimension. If this isn't what you are taking about then I have no clue. Your post was one of the most confusing I've seen in a while.

I edited previous message to make it more understandable with example.

Active forms work by replicating the first line down the rows as the user selections change. My belief is that you want to create asymmetric rows. The only way I think you could do this is to create a secondary dimension holding (say)
E1-P1
E2-P2
put that on the rows, then adjust the DBRW references to split the two out.