Welcome Guest! Log in


The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Mapping with Analytic functions

15 Jun 2016 14:04 #1 by letancel
Mapping with Analytic functions was created by letancel

I'd like to use an analytic function in a column of my mapping :
over (partition by
		order by extranet_retour.datetime_log desc)

When I execute the mapping I get an exception during the build sequence : Exception : Fatal error during transformation
I tried the same query with SQL Server Management Studio and it worked well, so it's not a syntax issue..

Are the analytic functions known to Stambia?

17 Jun 2016 22:24 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Mapping with Analytic functions
Analytics function can be used.
Are you sure the error is due to this expression ? If you replace it with width a simple <table>.<columnname> then it works ?