Dear All,

I am using Oracle database directly in analysis services without
getting data into SQLSERVER Data base.

And Now in data source view I want to use some function
Like I want to change the date format from standard to Mon dd,YYYY.

I can not use sqlserver function ,anyhow I need to use Oracle function.
When i used oracle function and try to browse the data in datasource
view iteself
I am getting error ORA00923 i.e. for FROM keyword not found where
expected.

Do I need to use Oracle function here or I can use SQLSERVER functions
also.?

Please help me in that

Vinay Puri

you have to use Oracle SQL command to create new calculated columns to
format the dates like you want. (create these new columns in the DSV)

"RICKY" <vinayusa (AT) gmail (DOT) com> wrote

Thanks for ur response

I tried that , but is not working
even simple arithmetic operator is also not wotking
like sales+100 is also giving the same error
"I am getting error ORA00923 i.e. for FROM keyword not found where
expected"

Am I missing something?


Vinay

have you try to create a view in Oracle and use this view instead of the
table in the DSV and the cubes.

"RICKY" <vinayusa (AT) gmail (DOT) com> wrote

I have created a view for fact table and
for dimensions i am using normal tables.

Thanks
ricky