TM1 Forum

Hi,

I have a websheet with 2 active forms, so the active form on the top is the master active form using Cube_A. The active form has only one Row dimension which is a very detailed dimension lets say Dimension_A . One of the columns in the Active Form is a PickList (Y/N) which allow the user to select the line.

I have an Action button that runs a TI process, which will use the Cube A as data source and will filter only the Lines selected by the user in Active Form, and will insert all these dimension elements into another Dimension ( DImension_B ) and also in the data tab, will populate Cube_B ( which uses Dimension_B ) with data from Cube_A.

SO My bottom Active form is build from Cube_B and its has the same layout with top active form, but it should show only what the user has selected in the top active form

Everything works fine, so I can see the process running successfully, and I can see the Cube_B gets populated properly.

But my second Active form, does not show the data for the rows that are selected during this session. It shows the rows being added at the end of Active Form, but none of the DBRW cells show any data, and they are all locked. Rebuilding the Websheet does not help, closing and reopening the websheet does not help, but if i logout and login again in TM1Web, then everything shows fine

Is this a known issue and is there any workaround for this?

Thanks

tm123 wrote:Hi,

I have a websheet with 2 active forms, so the active form on the top is the master active form using Cube_A. The active form has only one Row dimension which is a very detailed dimension lets say Dimension_A .

Let's not. I for one stopped reading at that point.

http://www.tm1forum.com/viewtopic.php?f=3&t=1037

When you post something like "Suppose I have cube A and Cube B, and my rule is ['value'] = N:DB('CubeA', 'dim1, dim2'" etc, then three things happen. One, you reduce the chance that a syntax or typing error will be spotted, which means wasting time bouncing posts back and forth to try to get to the root of the problem. Two, you are usually describing what you think is happening, which may not be what is happening. Three, some more experienced members won't even look at the question because they've had too much time wasted by the first two issues in the past.

If you restate your question giving full and complete details, you stand a much better chance of getting a reply.

Thank you for your comment. I tried to enter as much context as i could though but i indeed understand how hard is for other people to understand my issue

So my question is more like below:

When you have a websheet with an active form and an action button which when executed adds some new elements to the dimension used as row dimension in the active form ( referencing MDX statement ), and also populates the data in the cube for the new added elements, should the active form ( after websheet is refreshed or rebuilt ) show the data?

What I am.seeing is that it does not show the data until user disconnects and connects again.

Thank you

tm123 wrote:Thank you for your comment. I tried to enter as much context as i could though but i indeed understand how hard is for other people to understand my issue

So my question is more like below:

When you have a websheet with an active form and an action button which when executed adds some new elements to the dimension used as row dimension in the active form ( referencing MDX statement ), and also populates the data in the cube for the new added elements, should the active form ( after websheet is refreshed or rebuilt ) show the data?

What I am.seeing is that it does not show the data until user disconnects and connects again.

It is worth re-reading the guideline again to see exactly what the problem with abstract questions is, because it's also illustrated above.
- We don't know the name of the dimension that you are using.
- We don't know the structure of the cube(s), much less the layout of the active forms.
- We don't know what the MDX statement is.
- It's not even clear whether the subset that is powering the active form is one which is defined by MDX on the server, or defined as an argument to the TM1RPTROW formula, much less what arguments you have used to those formulas.

As a consequence any answer that you would get would be nothing more than a guess.

I have also experienced this issue, and i could not find a solution. In my case this happens only when there are more than 1 active forms in the websheet. In my opinion this is a bug but i did not spend much time with it since in my case i was able to change the design on my websheet.

Probably someone else has a solution for this.