Skip to main content

Tasks and Cubes


Harm Horstman
Superhero
Forum|alt.badge.img+21
Can anyone explain why table task parameters behave different in cubes?

It seems like that task parameters are only passed thru for primary key columns.

Or are additional settings required for this?
Did this topic help you find an answer to your question?
This topic has been closed for comments

9 replies

Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • May 1, 2019
Hi Harm,

A cube component shown a lot of data cells, which are linked to 0..* data rows of the subjects data source the cube is connected to. The task is executed on each related data row of the selected cell in the cube.

You can investigate which rows are concerned by double click on a cell in the Windows GUI to view the drill down data source.

I hope, this information is helpful to find out the input of the executed task.

Regards,
Erik

Harm Horstman
Superhero
Forum|alt.badge.img+21
I understand this, but I think it should be possible when the distinct number of task parameter values of the concerned rows equals 1.

It is hard to explain in a few words, if needed I can show you examples to make it more clear.

Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • May 1, 2019
True. In general, when executing a task or report for multiple rows the execution will only take place for distinct combinations of the input values.

Please, provide some examples to clarify your question.

Harm Horstman
Superhero
Forum|alt.badge.img+21
How do you like to receive examples? A movie?

Actually it is simple, we made a task which has 3 task parameters.

The task is linked to a table and the task parameters are connected to 3 columns is the table, but the PK key of this table is a based on a different (unique identifier) column.

If we run the task I would expect, it running a many times a the number of distinct combinations of the 3 columns which are linked as table_task_parameter.

Erik Brink
Moderator
Forum|alt.badge.img+5
  • Moderator
  • 497 replies
  • May 1, 2019
Harm Horstman wrote:
Can anyone explain why table task parameters behave different in cubes?

It seems like that task parameters are only passed thru for primary key columns.

Or are additional settings required for this?


Would you please describe the difference you mentioned and (faulty) behaviour you observe? Feel free to support your story with pictures or a short movie.

I would expect the GUI to work as you subscribe, both with or without a cube on the subject.

P.s. Is the PK value part of the drill down datasource in this case?

Moller Toma
Captain
Forum|alt.badge.img+11
@Harm Horstman has your question been answered?

Harm Horstman
Superhero
Forum|alt.badge.img+21
Not yet 100%, I need to prepare another test to simulate the issue.

Moller Toma
Captain
Forum|alt.badge.img+11
Hi Harm,

If you don't mind, I will close this topic because there's no activity for over a month now. If you have any questions about this topic in the future, just let me know so I can reopen the topic.

Harm Horstman
Superhero
Forum|alt.badge.img+21
  • Author
  • Superhero
  • 497 replies
  • July 25, 2019
Ok, no problem. At this moment I have other priorities.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings