73927

Converting Cognos reports to SSRS , what does XSUM command does?

We are in process of converting cognos reports to ssrs reports . i have a query which i got it from the cognos report and it is written in pervasive sql i am not sure about the language. I am able to interpret most of the query but i am stuck with one command XSUM. It has a syntax as

XSUM(col21 at col3 col7 col5 col5 for col3 col7) as col22 where col21,col3,col5, and col7 are columns from the table.

Can any one help me in understanding what the command XSUM does and what is the equivalent of it in T-sql please.

Thanks.

Answer1:

The X stands for extended.

Your report is probably doing some arithmetic on the application outside of the database that is generating these xsums and xmins.

Answer2:

The XSUM is just as Stephen has highlighted. It means calculations are being performed within the report itself. Is your report doing any roll ups or aggs across queries or subtotals in the crosstab itself or are you joining subqueries within a report. Once you have subqueries and tie them together, the arithmetic has to be performed on the application servers. Think of it as a two tier approach -> gather the data from the database that meets the criteria of the filters -> then aggregate the data on the application server before firing off to the UI.

Answer3:

You may want to looking at the native sql and cognos sql probably one of them may not have the Xsum.

Apart from this, will there be a semantic layer in SSRS where you have to create something similar to a package. If thats the case , would be better to recreate the report in SSRS.

Thanks PR

Recommend

  • use awk to process a csv (tab delimited) line by line
  • Sort data in a list to columns for xlsx files
  • Rowwise summation for Tibble datatype
  • How to transpose one or more column pairs to the matching record in Excel?
  • How do i join all data in 1 col of a table2 to table1 whilst keeping non matching data in table1
  • Hive Runtime Error: Unable to deserialize reduce input key
  • How to pageScroll mx.DataGrid programmatically?
  • Hadoop upgrade issue with web monitoring
  • Confluent Control Center Interceptor
  • Eiffel: is there a way to express a double implies clause in eiffel?
  • TinyXpath v_get_xpath_base, second parameter
  • Converting Cognos reports to SSRS , what does XSUM command does?
  • Dilemma with XSD, Generics and C# Classes
  • Variable height FlowLayoutPanel with right anchored static panel
  • Calculating every cartesian point in a circle
  • Calculate the distance between the iPhone and a door, knowing their physical widths
  • Difference between devpi and pypi server
  • keep var format as matrix after removing values
  • Find generic sub-lists within a list
  • Sum, Avg, Max, Min, Count of NULL values
  • join two tables with different number of rows(in sql server)
  • String matching
  • Netezza Incremental load from Sql server using SSIS
  • Excel distinct count with conditions
  • Converter from SAT to 3-SAT
  • Excel VBA How to populate a multi-dimensional (3d) array with values from multiple excel ranges?
  • How do I remove all but some records based on a threshold?
  • Primefaces :radioButton inside a ui:repeat
  • R convert summary result (statistics with all dataframe columns) into dataframe
  • Breaking out column by groups in Pandas
  • Unable to get column index with table.getColumn method using custom table Model
  • Is playing sound in Javascript performance heavy?
  • MonoTouch: How to download pdf incrementally as indicated in the Apple slides “Building Newsstand Ap
  • Admob requires api-13 or later can I not deploy on old API-8 phones?
  • Delete MySQLi record without showing the id in the URL
  • Unanticipated behavior
  • Comma separated Values
  • Trying to get generic when generic is not available
  • How to CLICK on IE download dialog box i.e.(Open, Save, Save As…)
  • apache spark aggregate function using min value