WBC("#COPY "&....) in a Application Studio action does not work

Hello,
we have a v12 multitenant environment, where we are trying to use the WBC("#COPY ",....) function in the action of a cell in Application Studio. We are doing a simple example, on a crossing of cube base elements.

These functions work correctly:
=WBC(666,C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=WBC(E20,C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=WBC("&W100",C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=WBC("#DELETE",C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=WBC(4,"CASH360","CMAPEOS",ReportObjects.lvDYEAR_To.Text,ReportObjects.lvDVERSION_To.Text,ReportObjects.lvDTIMPOM_To.Text,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)

But these do not work:
=WBC("#COPY "&C10&";"&C11&";"&C12,C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=WBC("#COPY "&C10,C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=WBC("#COPY "&ReportObjects.lvDYEAR_From.Text&";"&ReportObjects.lvDVERSION_From.Text&";"&ReportObjects.lvDTIMPOM_From.Text&";"&C13&";"&C14&";"&C15&";"&C16&";"&C17&";"&C18&";"&C19&";"&C20&";"&C21&";"&C22&";"&C23&";"&C24&";"&C25,"CASH360","CMAPEOS",ReportObjects.lvDYEAR_To.Text,ReportObjects.lvDVERSION_To.Text,ReportObjects.lvDTIMPOM_To.Text,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)

We have also checked that the cell definition is correct:
=CELLGET(C6,C7,I10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)
=CELLGET(C6,C7,C10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25)

Has anyone had this problem with WBC("#COPY",...)? Any idea what might be happening?

Regards.

Find more posts tagged with

Infor EPM Discussions

Comments

Israel Jimenez

A simpler example. A cube with two dimensions.

These actions work correctly:
=WBC(E43,"CASH360","CPARAM",ReportObjects.LV_Version_Target.Text,ReportObjects.LV_Measure_Target.Text)
=WBC("&W100","CASH360","CPARAM",ReportObjects.LV_Version_Target.Text,ReportObjects.LV_Measure_Target.Text)
=WBC("#DELETE","CASH360","CPARAM",ReportObjects.LV_Version_Target.Text,ReportObjects.LV_Measure_Target.Text)

and this one does not work:
=WBC("#COPY "&ReportObjects.LV_Version_Origin.Text&";"&ReportObjects.LV_Measure_Origin.Text,"CASH360","CPARAM",ReportObjects.LV_Version_Target.Text,ReportObjects.LV_Measure_Target.Text)

Thanks in advance.
Regards.

vikas-sharma

Hi Ijimemez,

I have tried the below and it worked

=CELLWRITE("#Copy "&ReportObjects.lv_year.Text,Database,Cube,....)

This is in version 11, what version are you using?

Israel Jimenez

Hello,
we are in version 12 multitenant in the cloud. And we are using the command in one cell action.

Regards.

0712131256598360.doc

martin-reischl

Hi,

what strikes me about your copy formula is that you are using semicolons between the arguments. All your "non-working" formulas have semicolons. Have you tried comma instead of semicolon?

Best Regards

Martin

Israel Jimenez

Hi Martin,
semicolons appear due to the regional configuration of our computers. This has never been a problem. However, we have tested changing the regional settings, so that the formula would be exactly as indicated in the documentation, and it did not work either.

Thank you.

Regards.

Israel.

martin-reischl

Hi Israel,

thanks for giving it a test.

I now did some testing on my own. I was able to do a multi-dimensional copy using this formula:

=CELLWRITE("#copy [dversio].[act];[dtime].[total].[2023]","MIS","TPLANNING",B5,C4,"[DLCURR].[LC (scaled)]",ReportObjects.lv_DADJUST.Text,"[DPSEGM].[Total].[Aggregations].[Groups].[C_AT].[20278]","[DDETAIL].[60].[MOVEMENTS].[-]","[DPRSEGM].[Sum].[EXTERNAL]",ReportObjects.lv_DACOUNT.Text)

It does need a semicolon in my environment - I configure my PC in English but somehow my Cloud environment asks for the German separator. It won't work with comma.

It works with #c as well as #copy, these are synonymous.

It works with CELLWRITE but not with WBC, which may just be due to the order of dimensions I am using.

Will you give it a try with CELLWRITE?

There does not seem to be a general issue with the copy command. One thing I found out is that I had to enable the option "Allow splashing on rule calculated cells" on the database since my cube has some stet rule on this cell.

This type of issues may be tricky to find out since you won't get an error message from an action. What I did is, I just used CELLGET and write-enabled the cell. Then I wrote the command directly into the cell, "#c [dversio].[act];[dtime].[total].[2023]". Then I'll get an error message in the Windows client. That helps me find any issues. Once that works, I copy the command into the action.

Best Regards

Martin

Israel Jimenez

Hello Martin,
thank you very much for your suggestions. The trick of pasting the code in the cell is very good. Finally we can have at least one error.

We have enabled the parameter "Allow splashing on rule calculated cells" in the OLAP configuration.

We have created a write-enabled cell, with this code:

=CELLGET("CASH360";"CPARAM";"[DVERSION].[HIERARCHY_DVERSION].[V99]";"[DMEDIDAP].[HIERARCHY_DMEDIDAP].[CF_IVA]")

Then in the client, in "View" mode, we have pasted the following code:

"#COPY [DVERSION].[HIERARCHY_DVERSION].[V01];[DMEDIDAP].[HIERARCHY_DMEDIDAP].[CF_IVA]"

And the error obtained is:
"
Error during EndExecute
Error:The unique name [DMEDIDAP].[Hierarchies] could not be resolved.
The unique name [DMEDIDAP].[Hierarchies] could not be resolved. (D:JenkinsMaster122312ProjectsolapSourcesBackTierModulesServerQueryEngineXMLAMDXEvaluatorMDXEvaluator.cpp, function Infor::BI::Olap::Mdx::MDXEvaluator::InitializeCalculatedMembers, line 860 (Kernel error code: 21216))
The unique name [DMEDIDAP].[Hierarchies] could not be resolved.
"

We do not understand where the "[DMEDIDAP].[Hierarchies]" comes from. Any idea?

Thank you very much.

Regards,
Israel.

Copyright © 2025 Infor. All rights reserved.