Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to define the export of FSG rowset and column set in SQL sentence". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to define and export the FSG rowset and column set in the SQL statement.

-- FSG rowset query-- query rowset IDSELECT t.axis_set_id, t.name, t.axis_set_type, t.descriptionFROM rg_report_axis_sets_v tWHERE t.name IN (name of the rowset to be taken) -- query the "calculation" SELECT rra.sequence, rra.description, rra.display_flag AS display row of the corresponding row set,-- display row rra.display_zero_amount_flag AS display zero,-- display zero rra.change_sign_flag AS change symbol,-- change symbol rra.change_variance_sign_flag AS scarlet letter write-off difference -- Scarlet letter write-off difference rac.segment1_low | |'. | | rac.segment2_low | |'. | | rac.segment3_low | |'. | rac.segment4_low | |'. | | rac.segment5_low | |'. | | rac.segment6_low | |'. | | rac.segment7_low | |. | | rac.segment8_low | |. | | rac.segment9_low upper limit | Rac.segment1_high | |'. | | rac.segment2_high | |'. | | rac.segment3_high | |'. | | rac.segment4_high | |'. | | rac.segment5_high | |'. | | rac.segment6_high | |. | | rac.segment7_high | |. | rac.segment8_high | |. | | rac.segment9_high upper limit | Rac.segment1_type | |'. | | rac.segment2_type | |'. | | rac.segment3_type | |'. | | rac.segment4_type | |'. | | rac.segment5_type | |'. | | rac.segment6_type | |'. | | rac.segment7_type | |'. | | rac.segment8_type | |. | | rac.segment9_type displays FROM rg_report_axes_v rra | Rg_report_axis_sets_v rras, rg_report_axis_contents racWHERE rras.axis_set_id = rra.axis_set_idAND rac.axis_set_id = rras.axis_set_idAND rac.axis_seq = rra.sequenceAND rras.name = 'rowset name' -- query the "calculation" SELECT rra.sequence, rra.description, rra.display_flag AS display rows of the rows corresponding to the rowset,-- display rows rra.display_zero_amount_flag AS display zero,-- display zero rra.change_sign_flag AS change symbol -- change the symbol rra.change_variance_sign_flag AS scarlet letter write-off difference rrc.axis_seq serial number, rrc.operator operator, rrc.operator constant, rrc.axis_seq_low offline Rrc.axis_seq_high launches FROM rg_report_axes_v rra, rg_report_axis_sets_v rras, rg_report_calculations rrcWHERE rras.axis_set_id = rra.axis_set_idAND rrc.axis_set_id = rras.axis_set_idAND rrc.axis_seq = rra.sequenceAND rras.name = 'rowset name' -- FSG column set query-- query column set IDSELECT * FROM rg_report_axis_sets_v t WHERE t.name IN ('name of column set') -- query column SELECT t.axis_set_id, t.position position, t.sequence sequence, t.display_format number format, t.factor coefficient, t.amount_type amount type corresponding to the column set T.unit_of_measure_id currency, t.parameter_num control value, t.period_offset offset, t.name column name, t.description description, t.percentage_divisor_seq percentage, t.display_flag display column T.display_zero_amount_flag shows zero, t.change_sign_flag scarlet letter sterilizes, t.change_variance_sign_flag scarlet letter sterilizes difference FROM rg_report_axes_v t, rg_report_axis_sets_v rrWHERE t.axis_set_id = rr.axis_set_idAND rr.name = 'column set name' At this point, I believe you have a deeper understanding of "how to define and export FSG rowsets and column sets in SQL statements". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.