You are building a view sure.
But I see no DatasourceType=‘VIEW’ or DatasourceNameForServer=sCube in your Prolog code. If you have set up the variables using a text data source then as Alan already suggested the NValue variable will be undefined. Code only does what you tell it.

Also when using a view as a data source for TI setting row and column dimensions has absolutely zero effect since the source is read one cell at a time. Likewise ViewSupressZerosSet is valid only for user consumed views in the cube viewer. For TI datasources you need to use the ViewExtractSkip... functions.

Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

You are building a view sure.
But I see no DatasourceType=‘VIEW’ or DatasourceNameForServer=sCube in your Prolog code. If you have set up the variables using a text data source then as Alan already suggested the NValue variable will be undefined. Code only does what you tell it.

Also when using a view as a data source for TI setting row and column dimensions has absolutely zero effect since the source is read one cell at a time. Likewise ViewSupressZerosSet is valid only for user consumed views in the cube viewer. For TI datasources you need to use the ViewExtractSkip... functions.

Thanks for your info, According to your answer I wrote DatasourceType=‘VIEW’ and DatasourceNameForServer= SrcCube in my Prolog.

Exactly, I want to get the value from my cube view using code. I don't want to select the view through clicking manually. What should I do?

If I want to do this "Don't want to select cube view to fetch my data" So, I will select Script Only then I will write the code I attached in Prolog tab then the Insertion of values will be in Epilog tab because in Script Only case there is no Data tab. Is this correct?

Epilog code is executed once and once only after the data source connection is closed. Any CellPutN here would update only one cell.

For the data source you of course want to select a view of the source cube that you will be processing. The manually selected view serves one purpose only: to declare the variables that will be needed per the dimensionality of the cube (and if the type is a cube view then the 3 extra implicit variables nValue, sValue & value_is_string). If you use DatasourceType, DatasourceNameForServer and DatasourceCubeView on the prolog then the manually selected view will never be used during runtime.

Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Epilog code is executed once and once only after the data source connection is closed. Any CellPutN here would update only one cell.

For the data source you of course want to select a view of the source cube that you will be processing. The manually selected view serves one purpose only: to declare the variables that will be needed per the dimensionality of the cube (and if the type is a cube view then the 3 extra implicit variables nValue, sValue & value_is_string). If you use DatasourceType, DatasourceNameForServer and DatasourceCubeView on the prolog then the manually selected view will never be used during runtime.

Dear lotsaram, Sorry for the latency but I spent much time trying to get a solution but unfortunately I cannot.
after that I know that I have a misconception ... I tried before to make a process for each cube separately but this not my target I want to create just one. If I can get a blog or an article from A - Z or if you can help to understand and Implement this type of process because all posts I saw written from the end not from the beginning.

I have a question, If I select a data source manually from a cube then I want to fetch data from another cube Is this okay?

I understood "we want to create a view to fetch data from" then make it as a source. How can I get the intersected values? How can I get each account? What are the variables I will use to manage that?

I tried before to make a process for each cube separately but this not my target I want to create just one. If I can get a blog or an article from A - Z or if you can help to understand and Implement this type of process because all posts I saw written from the end not from the beginning.

The best open source and free to use example you are going to get for this is the bedrock library. I suggest you yo there and look at the Bedrock.Cube.Data.Copy process

I understood "we want to create a view to fetch data from" then make it as a source. How can I get the intersected values? How can I get each account? What are the variables I will use to manage that?

No one is going to write your code for you. You need to understand the fundamentals of what a TI process does and how the data is processed one-cell-at-a-time. That's all from me untill you can prove that you have read and understood the request for assistance guidelines.

Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

No one is going to write your code for you. You need to understand the fundamentals of what a TI process does and how the data is processed one-cell-at-a-time. That's all from me untill you can prove that you have read and understood the request for assistance guidelines.

Hello there,

Firstly, thanks for your help I appreciate that.
Secondly, This solution "TM1" doesn't have any advanced tutorials like cookbook. This my first time I faced this problem "Process that you can change your data source in runtime".
Thirdly, If you can help fine if you cannot don't disturb yourself and write words disturb the others.

If I can get a blog or an article from A - Z or if you can help to understand and Implement this type of process because all posts I saw written from the end not from the beginning.

Lotsaram pointed you to a generic TI process (Bedrock.Cube.Data.Copy in Bedrock).
Please go there and dissect the code. It's the best thing you can do now.
Any to-the-point questions that you still have on the code, can be asked and effort will be made to answer them.