Showing results for 
Search instead for 
Did you mean: 

Using calculation view in excel with input parameters

0 Kudos


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??


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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).