SAC table in Excel Addin

[krishnapriya183]

Hi Experts ,

I added a table to excel sheet using excel addin for SAC.I have observed below . These changes can be done easily in BPC .

1) Dynamic formulas can not be added to the table i.e. formula should expand & collapse when hierarchy is expanded/Collapsed.

2) File can not be saved on the server, so that file can be linked to calendar tasks.

3) Inserting new columns to add formula between SAC columns can not be done.

Please suggest if you have tried and able to achieve these in SAC excel add-in.

Regards,

Krishna.

[Jay_Gandhi · Accepted solution]

Hi Krishna,

Items 2-3 are not supported.

Item 1 is not supported, however, is on the roadmap and will be supported eventually.

Jay

[sgodfree]

Hi Krishna,

Integrating SAC Add-in reports into the SAC file repository (item #2) is also on our roadmap, however this is still a few quarters out.

Thanks,

Scott

[krishnapriya183]

Thank you for replying . Please let us know if asymmetric reports are possible where in we can design the column order or row order.

Asymmetric reports/InputForms can be done easily in BPC 7.5 as well as EPM 10.