Using calculation view in excel with input parameters

[jmaravilla]

Hello

I have a calculation view which receives 2 input parameters for a range of dates, when i create the connecction with Excel i get the error "sql processing error: Hierarchy source query: SQL: column store error: search table error: [34092] search on calculation model requires parameters: Required variable $$MyVariable$$ is not set"

I would like to know how can i pass the parameteres from excel to my calculation view??

Thanks

[Former Member]

I doubt this can be achieved with a native Excel connection. Try SAP Advanced Analysis for Office. (I believe it may now just be called Analysis for Office).