Looping within Calculation View

[Former Member]

Hi

I have a calculation view that works on a single row of data and returns a few calculated columns using a generated random number, so the values in the calculated columns are different each time I do a data preview. Now, what I want to do, is to run the same calculation view over and over again, say 100 times, so that I can see 100 different values for the calculated columns but in the same table. If this is badly explained, let me know and I'll see if I can clear it up.

Can anyone help me achieve this?

Thanks

[Former Member · Accepted solution]

Thanks for the replies.

I changed my approach to storing the data into a permanent table as you said Ravi.

My problem is solved anyway.

[Former Member]

Hi Aakash,

Please refer to below thread, I have answered you question, I think.

http://scn.sap.com/thread/3395504.

Hope this can help you.

Regards,

Jerry

[Former Member]

Aakash,

I agree with Revindra, can you re-phrase your issue.

Regards

Shankar

[former_member184768]

Hi Aakash,

I got randomly lost in your explanation.

Do you mean to say that you wish the run the script 100 times and see 100 records of the calculated columns or do you wish to see 100 calculated columns in one record (row).

If you wish to see 100 records, then may be you will have to:

-- Put 100 select statements in a UNION

or

-- Run the script 100 times and insert the data to a table (temporary or physical)

or

-- Generate a dynamic script with UNION statements.

Regards,

Ravi