Setting up parameter for a where clause from stored procedure

#1

I have a stored procedure that I want to create a data cube for. It has 6 outputs and in the where clause for the SQL Server stored procedure, I have a @datestart and @dateend as parameters. How do I set those in the data cube? The field that I have the where clause is not a part of the the final output.

#2

https://www.dundas.com/support/learning/documentation/cleanse-consolidate-modify-data/using-manual-select-placeholders

https://www.dundas.com/support/learning/documentation/cleanse-consolidate-modify-data/how-to/passing-parameter-value-from-dashboard-to-stored-procedure

#3

Thanks James. I followed these instructions, however, when I go to connect the string value filter to the table, the placeholder doesn’t show up in the filter visualizations window. Any ideas?

#4

Not with out looking at your project, I suggest contacting support they can set up a web-ex

#5

Hello @brandon.maurer,

You have to make your placeholder public from the cube. Did you tried it?