1 / 46

NovaView Advanced configuration

NovaView Advanced configuration. 2/11/2011. Good Morning!. http://www.youtube.com/watch?v=GT86iWiH2mI&feature=related. The Goal. To be able to understand and effectively use the advanced NovaView configuration settings

jackson-david
Download Presentation

NovaView Advanced configuration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NovaView Advanced configuration 2/11/2011

  2. Good Morning! http://www.youtube.com/watch?v=GT86iWiH2mI&feature=related

  3. The Goal • To be able to understand and effectively use the advanced NovaView configuration settings • To enhance and improve the using of NovaView configuration and adjust it to users needs • To be able to resolve questions and issues using advanced configuration

  4. Contents • Introduction - why, how and when to use? • Advanced Book Properties • NovaView Server administration settings • Non UI settings (registry) • Data settings • Security settings • Debug settings • Useful features • Shortcuts

  5. Advanced Book properties • Cache Views Data • Enforce OLAP Security • Hide This Book • Hide Private Book • Detect Clients Locale

  6. NovaView Server Administration Settings • Virtual directory • Members in dimension tree – default 1000 • Roles to apply on anonymous user • Default domain

  7. Virtual directory • Requires access here: • Also controls by non-UI settings (registry keys): IISPath, ServerPath

  8. Members in dimension tree • The maximum number of members to retrieve when a user expands a branch in a dimension hierarchy • Recommended if there are large dimensions • Affects Web clients only Shows only 1000

  9. Roles to apply on anonymous user • The security role to automatically apply to a user who is not associated with any of the defined roles • Used in case the Panorama directory set to work with Anonymous (for external users)

  10. Security tab • The Security tab enables you to implement a security level that is higher than the one established via NovaView briefing book security. This security mechanism will apply to all NovaView users apart from those included in an exception list. Details: Chapter 4, NovaView Developers Guide • Force using high security on all views (for Classic Analytics only). • Force using high security on rendering services : Including export to PDF, Excel, View to JPG ect.

  11. Advanced Server Properties • Number of Data sessions • Each pnSessionHost represents individual data connection to the OLAP server. • The default value is 25. Maximum tested value: 32 • Depends on : • number of users (doesn’t mean users number!) • amount of queries (usage level) • query complexity. • For environments with many concurrent users, it is good to have a high number. • Less than 20 users: 5-10 connections. • The sessions will disappear only when you restart the Panorama service or if you manually stop them.

  12. Advanced Server Properties • Query Timeout: Set the timeout for queries, in minutes. NovaView Server will cancel queries exceeding the allowed amount of time. • Set the timeout for idle data sessions, in hours. NovaView Server will discontinue sessions exceeding the allowed amount of time

  13. Additional connection strings • What is a connection string? Example: • ServerConnectionString with value Query Timeout=100; • Full properties list. • NOTE: Not all of them might be supported with NovaView

  14. Additional connection strings: UI test • After Connecting Data Source=ANNAU;Provider=MSOLAP;MDX Compatibility=2;MDX Unique Name Style=3;;Roles=Admin;MDX Missing Member Mode=ignore;Query Timeout=100;

  15. Non-UI Server Advanced setting – the registry keys • Security: change modes • Data: non empty, different calculation, formatting ect. • Performance • Debugging • Additional features

  16. How it works & Usage • Most settings work per sever , for all users by default • Some settings can be set per view • Some settings can be set in UI, some in registry • The usual values are 0 or 1 unless stated otherwise • Set under HKEY_LOCAL_MACHINE\SOFTWARE\Panorama\NovaView 6.2\Admin (32bit)

  17. Data registry • Affect MDX Structure in various ways • There’s no “wrong” or “right” MDX: it’s all depended on your needs • Some needs may contradict, hence need to use wisely

  18. MDX Basic Structure http://www.sqlservercentral.com/articles/Video/65072/ SELECT[Date].[Calendar Year].MEMBERS on 0 , [Product].[Product].MEMBERS on 1 FROM [Adventure Works] ) WHERE[Measures].[Sales Amount] Further reading: MDX the basics

  19. Coffee time

  20. UseForceMemberScopeIsolation •  Add scope isolation property to calculated member MDX syntax. • Adding Scope_Isolation to calculated member will generate the cube calculation to be executed before or together (using solve order) with query calculations.

  21. Usage of UseForceMemberScopeIsolation • Doesn’t require NVI restart • Can be used per view as such: /* UseForceMemberScopeIsolation=0*/ in view Annotation will override the registry UseForceMemberScopeIsolation=1 /* UseForceMemberScopeIsolation=1*/ in view Annotation will override the registry UseForceMemberScopeIsolation=0, or if registry is not present. • This type of Annotation can be controlled only through the Panorama Analytics Client. • This Annotation is invisible in the Panorama Web Client.

  22. What is scope? And it’s isolation? • A calculated member can occur be created within one of the scopes Query scope The visibility and lifetime of the calculated member is limited to the query. The calculated member is defined in an individual query. Query scope overrides session scope. Session scope The visibility and lifetime of the calculated member is limited to the session in which it is created. The CREATE MEMBER statement creates a calculated member with session scope. Scope Isolation: When a MDX script contains calculated members, by default the calculated members are resolved before any session-scoped calculations are resolved and before any query-defined calculations are resolved. Creating Query-Scoped Calculated Members (MDX).

  23. Example with without

  24. Limitation of Scope Isolation • Using this registry may create an issue if creating an out of scope calculations, such as formulas on Time dimension, for example. The key is not ON by default because it conflicts with calculated members referring to members in this attribute

  25. AllowSetinWhereClause • Creates sets with curly braces in WHERE instead of pnMulti calculated member. On v 6.2 becomes default • pnMulti calculated member calculates multiple selection members sum

  26. AllowSetInWhereClause Example

  27. UseSubSelectMDX • Adds the sliced members to the sub-select clause • Subselect expressions are nested SELECT expressions that are used to restrict the space of the cube from where the outer external SELECT is being evaluated. Subselects allow you to define a new space over which all calculations are evaluated. • Further reading: Subselects in Queries • difference between WHERE and SUBSELECT • http://www.mosha.com/msolap/articles/mdxmultiselectcalcs.htm

  28. MDX Example to SubSelect SELECT [Date].[Calendar Year].MEMBERS on 0 , [Product].[Product].MEMBERS on 1 FROM(SELECT TOPCOUNT( [Product].[Product].CHILDREN , 10 , [Measures].[Sales Amount] ) ON 0 , [Sales Territory].[Sales Territory].[Region].[France] on 1 , [Sales Channel].[Sales Channel].[Internet] on 2 FROM [Adventure Works] ) WHERE[Measures].[Sales Amount]

  29. What it does & When should be used? • Creates a sub cube in the MDX statement to allow better performance. Default after 6.2 • Should be used when the attribute in the grid and the attribute user slicer in the slicer pane are from the same dimensions (parallel). • When using multiple selection on this attribute

  30. Example: UseSubSelectMDX

  31. Security registry • YukonServers Changes the way the roles requested from OLAP server. May improve the work with roles in certain servers. • ImpersonateUsers Add effectiveusernameproperty to MDX connection string for connecting per user, not impersonating role name.

  32. Performance RemoveAllFromWhere Removing embers with "All" level from Where clause UseAdvDimStruct • Increases performance when expanding huge dimensions • This mode allows for expanding huge dimension w/o the overhead of generating all parents. This should be checked for saving\loading and any operation that applies to expanding members (value filter, expand, collapse) in tree and in the crosstab. • Server registry • Requires restart of NV. • Non-default. • For cases where expanding / nesting/ top count - every opening dimension that has low performance. • The ration between #of father and children is very small

  33. Useful Features ShowFmlRepository: Ability to use formula repository – ability to save a created formula as private or global and then to share it with other users.

  34. Useful Features ShowSubsAndAlerts: Enables Alerts feature in Java client and export a view to SharePoint Alerts = ability to send view by defined trigger to email address Subscribe = Make the view visible in “Subscription list” in SharePoint

  35. More Useful Features • IgnoreShowMG: Removes the measure groups and presents measures in flat list (requires browser restart ONLY)

  36. More Useful Features • AlwaysShowActions (for AS 2008): Make “Actions” option visible in all views (even if no actions defined). • Helps to prevent situation when action isn’t “caught” by action searcher

  37. More Useful Features • UseFillAxisColumns (for Export to Excel) Allows to repeat the first nested dimension name when exporting to Excel View Excel export-standard With key enabled

  38. Features MaxMemberProperties (remove limit) • While creating a member selection based on Member properties the list is limited to 1000.This registry allows to change this ShowKeyInSearchResults • Ability to show a member’s key in addition to a short caption within the search results.

  39. Debug & solve issues • DebugServer=1: Understand and track Web application issues related to NVI service and all Web applications • DebugNewAdmin=1 (from v 6.x): Track issues related to Dashboard, Flash & UDC • DebugExcelClient=1:Track Excel client • DebugDelivery=1: Track delivery view sending

  40. More debug features… • ShowMdxErrors=1 • TraceQueries=1 Create MDX tracking under C:\Program Files\Common Files\panorama\log Must create the folder “log” manually File example:

  41. Nice features • XPLook=1 • Doesn’t require restart

  42. Recommended Shortcuts • Restart NovaView service – depends on usage • Unite the consoles • Ctrl + F5 in Desktop client = reconnects to server • Ctrl + F7 – Save current view

  43. Example for *.BAT file Instructions • Create *.txt file • Copy-paste the following content • Save as *.bat • Add a nice icon (Icon Archive), (How) You got the shortcut file! This one will restart NovaView Intelligence Service: @echo off net stop "NovaView Intelligence Server" /y start /wait net start "NovaView Intelligence Server" This one will stop the IIS @echo off net stop “IIS Admin Service” /y

  44. Control it all (with single custom MMC) Instructions

  45. Time for Questions

  46. The end • Please send feedback & suggestions to abylina@panorama.com

More Related