Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
Advise on Pivot Table & Functions | Excel Discussion (Misc queries) | |||
How to read a blank cell as zero for formulas? | Excel Discussion (Misc queries) | |||
Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions |