question

siera_gld avatar image
siera_gld asked

SSAS/Oracle Data Sources

I am trying to only select a subset of information in a fact table by using x number of months In my named query to an oracle table I am using Where Invoice_dt >= '1/1/2012' but I keep getting invalid month errors.
oraclessasdates
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
You can convert the constant to date using [to_date][1] or similar function and specifying correct format. for example. Where Invoice_dt >= to_date('2012/01/01', 'YYYY/MM/DD') [1]: http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions183.htm
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.