Create getdate() condition in universe

[Former Member]

Dear Experts,

I need to add to an @prompt condition in the universe, the default value getdate() but SQL Server is not recognizing that function.

How am I able to create a dimension with select getdate()?

thanks in advance,

Inê

[Former Member · Accepted solution]

getdate() is fine.

It will not parse because getdate() does not come from a table.

Designer tries to parse it as "SELECT getdate() FROM", which obviously fails.

Don't associate a table with it just to get it to parse though.

Try it in a query before changing it.

If you are still struggling, there is a good article by Dave Rathbun:

http://www.dagira.com/2008/07/21/using-a-magic-date-value-in-prompts/

Regards,

Mark

[Former Member]

Is the error message like "Statement could not be prepared"?

It doesn't matter you can use getdate(), anyway. It's just what me map says. Just ignore that error message but make sure that your logic is oK.