![]() |
OLAP write back via formulas (functions), not read only pivot tab
Default OLAP Analysis Services access in Excel is read only pivot tables. Is
there a reasonably priced Excel add-in that allows MS OLAP Analysis Service cube cell access via formulas (functions)? What I'm looking for is the way Applix TM1 or Paris Technologies PowerOLAP works with "OLAPwrite" formulas with their dedicated OLAP servers, but I want it to work with MS OLAP Analysis Services. I am specifically looking for MS OLAP Analysis Services Write Back to the cube to budget only scenarios while simultaneously displaying Read Only Actuals. The pivot tables also have formatting problems where the formulas retain formatting with no problems. |
All times are GMT +1. The time now is 04:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com