Jump to content

spotfire ADS issues

Tom Tang 2

Recommended Posts

hi there

there is rara information/materials about spotfire ADS(composite software studio), we are usually stuck if we have ADS sort of issues.

below are 2 issues if anyone could suggest

1) I am turning a sql server sql into an ADS view definition, in this sql as below there are 2 row_number() , ADS will give error saying row_number function is not natively supported, but if I remove the outside row_number and only keep inside one, it works fine.

srelect * from

(select ........row_number() over (partition by ...order by) rn1

from ( select ......row_number() over (partition by ...order by) rn2

from tableA

) a where a.rn1=1

) b where b.rn2=1


2) regarding ADS view caching, after the view migrated from dev environment, and setup caching schedule as dev, but it will not refresh automatically, checked the schedule is up and enabled, seems no issue for schedule details, not sure why it does not function as expected.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...