Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set parameters for a query #16

Open
jaapandre opened this issue Apr 22, 2016 · 1 comment
Open

Set parameters for a query #16

jaapandre opened this issue Apr 22, 2016 · 1 comment

Comments

@jaapandre
Copy link

When using parameters for a query it would be usefull if we could tell pash to set the parameters, for instance set ${type} for query below, but of course multiple parameters would be necessary.
SELECT NON EMPTY {[Measures].[Sum]} ON COLUMNS, {LastPeriods(15, CurrentDateMember([Date], '["Date.Year_month"]\.[yyyy-mm]') )} ON ROWS FROM [SomeCube] WHERE {[ype.Name].[${type}]}

@rpbouman
Copy link
Owner

Nice new feature. To implement this I think I should rely on simple text-based substiturion (i.e. macro's).
In addition, we need a new SET command, something like

SET VARIABLE type = 'value';

And

SET VARIABLE type = null

to unset a variable.

Would be nice to make it so that if a variable is not SET prior to executing the query, user should be prompted to enter a value.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants