Sunday 6 November 2011

Smart View vs The Classic

I just wanted to quickly post on the Smart View vs Classic add-in situation. I am as happy as the next person with the progress we have seen in Smart View and feel it has finally become a complete product, especially one that we can be happy to get clients on to.

With all this talk of Smart View reaching 'classic' functionality parity though I feel like people have forgotten what it was like to use the add-in of old (or perhaps, using the addin pre Excel 2007). My gripe isn't the features, its the lack of simplicity and speed. I'm comparing to Excel 2003 and the add-in. I love using the classic add-in with 2003 as I can literally do what I want to do as fast as I can think (that's either an insult or my hands are lightning fast right?).

I have no doubt though that there has been numerous occasions where (as a developer/consultant) I have gone from a blank desktop to the answer to my query faster than you could drop 2 of your 10 dimensions from the point of view (yes I know the POV can be turned off in .102, its my new favourite button).

These days I use Excel 2010 (which I also love) with Smart View but can't help but stop and take a breath of fresh air every time I open up 2003 at a client site somewhere. It mainly comes down to the way Microsoft changed the ribbon I believe which made keyboard shortcuts more difficult.  I also doubt it is on anyone's priority list either because it probably does affect the techy folk more than the end-users unfortunately (for us).

Note: There is a way you can link ALT-[1-9]  to Essbase commands as written on the Essbase Labs blog but I don't really like this as I can never remember which number is what.

Summary: Smart View updates are great, I miss my keyboard shortcuts

Tuesday 7 June 2011

Notepad++ User Defined Styles for Working with Essbase

Hi There

Not exactly a proper introductory first post but I'm not exactly a man of many words anyhow (maybe I'll get to a 'first post' later)..

I have been thinking about content for a blog for some time and one of the items on the list was putting up the notepad++ styles I use because it seems like many don't even realise the functionality exists. Essentially user defined styles allow you to set up custom syntax highlighting. I noticed

Check out CV's blog for details on Notepad++ and installing (trying not to steal/duplicate his blog post content!)

CalcScript Style (CalcScript.xml)

    <UserLang name="CalcScript" ext="csc" author="Daniel Willis" website="">
            <Global caseIgnored="yes" />
            <TreatAsSymbol comment="yes" commentLine="no" />
            <Prefix words1="yes" words2="no" words3="yes" words4="no" />
            <Keywords name="Delimiters">&quot;00&quot;00</Keywords>
            <Keywords name="Folder+">LOOP FIX EXCLUDE</Keywords>
            <Keywords name="Folder-">ENDLOOP ENDFIX ENDEXCLUDE</Keywords>
            <Keywords name="Operators">- ! % ( ) , : ; + &lt; = &gt;</Keywords>
            <Keywords name="Comment">1/* 2*/ 0</Keywords>
            <Keywords name="Words1">@</Keywords>
            <Keywords name="Words3">&amp;</Keywords>

            <WordsStyle name="DEFAULT" styleID="11" fgColor="000000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="FOLDEROPEN" styleID="12" fgColor="0000FF" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="FOLDERCLOSE" styleID="13" fgColor="0000FF" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="KEYWORD1" styleID="5" fgColor="FF8000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="KEYWORD2" styleID="6" fgColor="0000FF" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="KEYWORD3" styleID="7" fgColor="FF0080" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="KEYWORD4" styleID="8" fgColor="FF0000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="COMMENT" styleID="1" fgColor="008000" bgColor="FFFFFF" fontName="Consolas" fontStyle="2" />
            <WordsStyle name="COMMENT LINE" styleID="2" fgColor="000000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="NUMBER" styleID="4" fgColor="400040" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="OPERATOR" styleID="10" fgColor="FF0000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="DELIMINER1" styleID="14" fgColor="408080" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="DELIMINER2" styleID="15" fgColor="000000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="DELIMINER3" styleID="16" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />

MAXL Script Style (MAXL.xml)

    <UserLang name="MAXL" ext="mxl" author="Daniel Willis" website="">
            <Global caseIgnored="no" />
            <TreatAsSymbol comment="yes" commentLine="no" />
            <Prefix words1="no" words2="no" words3="no" words4="no" />
            <Keywords name="Delimiters">&apos;&quot;0&apos;&quot;0</Keywords>
            <Keywords name="Folder+"></Keywords>
            <Keywords name="Folder-"></Keywords>
            <Keywords name="Operators">( ) , . ;</Keywords>
            <Keywords name="Comment">1/* 2*/ 0</Keywords>
            <Keywords name="Words1">aggregate level uda direct force&#x000D;&#x000A;aggregate_missing aggregate_storage any bitmap buffered cache_pinning write zlib unicode_mode unlimited single seconds runtime rle read nonunicode_mode&#x000D;&#x000A;multiplication never no_access none optional optional_group minutes meta_read immediate committed_mode definition_only days division</Keywords>
            <Keywords name="Words2">account_type administrator aggregates aggregate_assume_equal aggregate_sum all_users_groups alternate_rollups  application_access_type apply aso_level_info auto_password backup_file based buffer_id &#x000D;&#x000A;build cache_size calc_formula globally view_file views vector values username_as_password transformation  storage storage_info structure_file subtract&#x000D;&#x000A;sss sss_mode shared_services_native self_session_info singlecell selecting runtime_info score resync reregister remote  query_data query_tracking&#x000D;&#x000A;purge project private preserve_groups output override outline_id options non_unique_members move nothing only metadata_only migr_modified_access miner &#x000D;&#x000A;member_property member_data manager max_file_size load_buffer locked max_disk_size initialize inactive ignore_missing_values ignore_zero_values &#x000D;&#x000A;force_dump file_location failed_sss_migration existing_views eas_loc dump dml_output exact data_storage currency_category copy_subvar copy_useraccess &#x000D;&#x000A;creation consolidation config_values cnt_sempaphore column_width compact compression_info cell_status change_file client *</Keywords>
            <Keywords name="Words3">alter application alter database alter filter alter group alter object alter partition alter session alter system alter tablespace alter trigger alter user create application create calculation create database create filter create function create group create location alias create macro create outline create partition create trigger create user display application display calculation display database display disk volume display filter display filter row display function display group display location alias display lock display macro display object display partition display privilege display session display system display tablespace display trigger display trigger spool display user display variable drop application drop calculation drop database drop filter drop function drop group drop location alias drop lock drop macro drop object drop partition drop trigger drop trigger spool drop user execute calculation export data export lro grant import data import dimensions import lro query database login refresh custom definitions refresh outline refresh replicated partition Data abort active add advanced after alias alias_names alias_table all allow alter append application archive area as at attribute attribute_calc attribute_info attribute_spec attribute_to_base_member_association autostartup b before begin blocks calc_script calc_string calculation cascade clear columns commands comment commitblock compression connect connects copy create create_application create_blocks create_user cube_size_info currency currency_conversion currency_database currency_member currency_rate custom data data_block data_cache_size data_file data_file_cache_size database database_synch database_asynch dbstats default definitions delete designer dimension dimensions direction directory disable disabled disallow disk display drop dynamic_calc enable enabled end end_transaction enforce eqd error error_file estimated event  excel exceeds execute export export_directory external from file file_size file_type filter filter_access function gb get grant group ha_trace held high hostname identified  implicit_commit import in inactive_user_days index index_cache_size index_data index_page_size information input instead invalid_block_headers invalid_login_limit io_access_mode kb kernel_io kernel_cache kill level0 license_info linked list load local location lock lock_timeout logfile login logout lotus_2 lotus_3 lotus_4 low lro macro mapped max_lro_file_size mb medium member member_alias_namespace member_calculation member_comment member_fixed_length_data member_formula member_info member_name_namespace  member_uda member_uda_namespace member_variable_length_data minimum mining  mode model mutex note of off on opg_cache opg_state or outline outline_paging_file overview partition partition_file partition_size password password_reset_days performance permission persistence pmml_file ports pre_image_access preserve privilege process property protocol query recover refresh remove rename repair replace replicated report_file request request_history reset restructure result retrieve_buffer_size retrieve_sort_buffer_size reverse row rows rules_file  scope  security security_backup select  selection semaphore server session session_idle_limit session_idle_poll set short shutdown size spec spinlock startup statistics status stop stopping supervisor suppress sync system table tablespace task tb template text thread to total_size  transparent trigger trigger_spool two_pass_calc type unicode unload unlock update updated updates use user using validate variable  verification version volume when with wizard worksheet exit by</Keywords>
            <Keywords name="Words4"></Keywords>
            <WordsStyle name="DEFAULT" styleID="11" fgColor="000000" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="FOLDEROPEN" styleID="12" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="FOLDERCLOSE" styleID="13" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="KEYWORD1" styleID="5" fgColor="FF0000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="KEYWORD2" styleID="6" fgColor="808080" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="KEYWORD3" styleID="7" fgColor="0000FF" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="KEYWORD4" styleID="8" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="COMMENT" styleID="1" fgColor="008000" bgColor="FFFFFF" fontName="Narkisim" fontStyle="0" />
            <WordsStyle name="COMMENT LINE" styleID="2" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="NUMBER" styleID="4" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="OPERATOR" styleID="10" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="DELIMINER1" styleID="14" fgColor="8080FF" bgColor="FFFFFF" fontName="Consolas" fontStyle="0" />
            <WordsStyle name="DELIMINER2" styleID="15" fgColor="8080FF" bgColor="FFFFFF" fontName="" fontStyle="0" />
            <WordsStyle name="DELIMINER3" styleID="16" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0" />

TIP: You can either manually insert this XML into your userDefineLang.xml file or you can use the 'Import' button on the 'User Defined Dialogue' panel accessed from the View menu.