Module: OlapViewHelper

Defined in:
app/helpers/olap_view_helper.rb

Instance Method Summary collapse

Instance Method Details

#olap_view_chart_by_mdx(chart, mdx, args = {}, properties = {}) ⇒ Object 



15
16
17
18
 
# File 'app/helpers/olap_view_helper.rb', line 15

def olap_view_chart_by_mdx chart, mdx, args={}, properties = {}
  xmla = Olap::View.request mdx, args
  olap_view_chart_by_xmla chart, xmla, properties
end

#olap_view_chart_by_xmla(chart, xmla, properties = {}) ⇒ Object 



20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'app/helpers/olap_view_helper.rb', line 20

def olap_view_chart_by_xmla chart, xmla, properties = {}
  id = olap_view_random_id

  if xmla.response.rows && !xmla.response.rows.empty?
    html = "<div id='#{id}'></div>"
    html += javascript_tag(render partial: "olap-view/#{chart}.js",
                                  locals: {id: id, data: xmla, properties: properties})
  else
    html = "<div id='#{id}'>#{Olap::View.options[:no_data]}</div>"
  end
  html.html_safe
end

#olap_view_charts_init ⇒ Object

Initialize Goole Charts API Paste it into <head> to your layout

<head> … <%= olap_view_charts_init %> </head>



11
12
13
 
# File 'app/helpers/olap_view_helper.rb', line 11

def olap_view_charts_init
  javascript_include_tag 'https://www.google.com/jsapi'
end

#olap_view_filling_table(data, dimension = nil, measures = []) ⇒ Object 



43
44
45
46
47
48
49
50
51
52
53
54
55
 
# File 'app/helpers/olap_view_helper.rb', line 43

def olap_view_filling_table data, dimension = nil, measures = []
  html = ''
  data.dimensions_caption(dimension).each do |d|
    html += "data.addColumn({type: 'string', label: '#{escape_javascript d[:caption]}', id: '#{escape_javascript d[:name]}', p:{'type': 'dimension'}});\n"
  end
  data.measures_caption(measures).each do |m|
    html += "data.addColumn({type: 'number', label: '#{escape_javascript m[:caption]}', id: '#{escape_javascript m[:name]}', p:{'type': 'measure'}});\n"
  end
  data.table(dimension, measures).each do |row|
    html += "data.addRow([#{olap_view_render_row row}]);\n"
  end
  html.html_safe
end

#olap_view_render_row(row) ⇒ Object 



33
34
35
36
37
38
39
40
41
 
# File 'app/helpers/olap_view_helper.rb', line 33

def olap_view_render_row row
  row.collect{|r|
    if r[:type] == 'dimension'
      "{v: '#{escape_javascript(r[:value] && !r[:value].empty? ? r[:value] : olap_view_unknown_element)}', p:{className: 'google-visualization-table-td #{r[:type]}'}}"
    else
      "{v: #{r[:value]}, f: '#{r[:fmt_value] || r[:value]}', p:{className: 'google-visualization-table-td #{r[:type]}'}}"
    end
  }.join(',').html_safe
end