class Twb::Analysis::SheetFiltersAnalyzerA
Attributes
localEmit[RW]
Public Class Methods
new()
click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 28 def initialize init @funcdoc = {:class=>self.class, :blurb=>'Analyze Worksheet filters.', :description=>'Documents Quick Filters and the values they employ, if any. Work in progess.',} #-- docFileName = docFile('WorksheetFiltersA.csv') $sheetFieldsCSV = CSV.open( docFileName ,'w') $sheetFieldsCSV << ['Workbook','Worksheet','Filter Type','Operation','Data Source','Field','Value','Alias', 'Alias?'] addDocFile docFileName, "Workbooks, Worksheets and the sheets' Quick Filters" #-- @sheetCount = 0 @filterCount = 0 end
Public Instance Methods
metrics()
click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 41 def metrics { '# of Worksheets' => @sheetCount, '# of Worksheet Filters' => @filterCount } end
parseFilters()
click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 56 def parseFilters @worksheets = @twb.worksheets @worksheets.each do |sheet| emit "\n\nSHEET: #{sheet.name}" filters = sheet.filters filters.each do |filter| filter.emit "-----------------------------\nWORKSHEET:: #{sheet.name}\n-----------------------------" if filter.values.empty? # $sheetFieldsCSV << ['Workbook','Worksheet','Filter Type','Operation' ,'Data Source','Field','Value','Alias', 'Alias?'] $sheetFieldsCSV << [@twbName ,sheet.name, filter.type ,filter.inexclude, filter.dataSource.uiname, filter.uiname,nil,nil,nil] end filter.values.each do |valueMap| value = valueMap[:value] valias = valueMap[:alias] same = value.eql? valias # puts "RECORDING FILTER VALUES: %-25s -- %-25s same? %s " % [value,valias,same] $sheetFieldsCSV << [@twbName ,sheet.name, filter.type ,filter.inexclude, filter.dataSource.uiname, filter.uiname, value, valias, same] end end end end
processTWB(twb)
click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 48 def processTWB twb @twb = twb @twbName = @twb.name emit " -- #{@twbName}" @twbDomainsLoaded = false parseFilters end