[PDF] Large Scale ASO- Making Essbase Silky Smooth with Terabytes



Previous PDF Next PDF







Animal Services Office - Austin, Texas

Top 3 Challenges 1 Reducing overall response time and providing outreach services will further decrease intake and better address instances of neglect before they rise to levels of cruelty 2 Animal Protection Officers do not have remote technology capabilities This impacts efficiency in call dispatch, data entry, and access to records



Large Scale ASO- Making Essbase Silky Smooth with Terabytes

#Kscope Agenda Introduction Major&ASO&challenges Getting&the&most&from&your&hardware Q&A



Administrative Services Organization (ASO) Provider

to serve as the Administrative Services Organization (ASO) to enhance the provision of quality services for West Virginia’s Medicaid recipients In August 2003, APS Healthcare, Inc (APS) embarked on a new contract with WV-DHHR that included Medicaid and Bureau for Behavioral Health and Health Facilities



Challenges, Opportunities, and Costs of Electronic Fisheries

EM and the associated challenges, opportunities, and costs, we reviewed the EM literature, conducted background interviews with EM and ASO stakeholders, and created an easy to use but comprehensive financial spreadsheet to analyze EM and ASO cost drivers The overall results showed that the use of EM in fisheries is still uncommon but



Optional program offerings: ASO plans

challenges and chronic conditions Outreach to 3x as many employees as our core program Each employee is supported by a dedicated nurse (1 nurse per 7,500 members) who works with a specialty care team and can act as a guide, coordinator and interpreter Can reduce costs with earlier intervention and support for serious conditions



FY 2022 Operating Budget testimony - dbmmarylandgov

Ongoing Challenges with the Functionality of ASO Given reported ongoing problems with the new ASO since the end of estimated payments, DLS is recommending committee narrative on the progress of the new ASO’s functionality This report should be a series of reports, the first of which, in consultation with the



SALISH BEHAVIORAL HEALTH ADMINISTRATIVE SERVICES ORGANIZATION

challenges experienced by some community partners regarding the new system SBH-ASO staff are continuing community outreach work to ensure continued success Salish Behavioral Health Administrative Services Organization Page 3 January 17, 2020



TPAs vs ASOs: The differences matter

ASO plan offerings are limited to those available through their parent carrier and can be restrictive when compared with TPA offerings 2 Flexibility: Plan performance and member satisfaction are tied to the networks, providers and benefits offered TPAs can build plans that incorporate those providers and networks that



SALISH BEHAVIORAL HEALTH ADMINISTRATIVE SERVICES ORGANIZATION

the challenges surrounding the MCO contract requirement of semi-annual reconciliation This process of MCO reconciliation involves the comparison each MCO’s Medicaid Members’ utilization of crisis services to the overall cost of SBH-ASO Crisis System



Oligonucleotide-based Therapeutics, Development and

This thesis discusses the progress and challenges for the development of ASOs and aptamers as therapeutics mRNAs, ribozymes, immunostimulatory oligonucleotides and CRISPR guide RNAs are out of the scope of this thesis

[PDF] classement roc d'azur 2017

[PDF] diplome universitaire psychologie par correspondance

[PDF] formation ? distance bordeaux 4

[PDF] formation ? distance université gratuite

[PDF] formation ? distance archéologie

[PDF] formation géologie par correspondance

[PDF] dut génie biologique par correspondance

[PDF] enseignement ? distance université de lorraine

[PDF] ead montpellier inscription

[PDF] évaluation classification des animaux cm1

[PDF] classer les êtres vivants 6ème

[PDF] classification des animaux cycle 3 trace écrite

[PDF] classer les êtres vivants cm1

[PDF] séquence biodiversité cm2

[PDF] classification des animaux cycle 3 évaluation

#KscopeLarge Scale ASO: Making Essbase Silky Smooth with Terabytes of DataBrian MarshallUS-Analytics

#KscopeAgendalIntroductionlMajor ASO challengeslGetting the most from your hardwarelQ&A

#KscopeIntroduction -About Brian Marshalll10+ Years IT and EPM/BI ExperiencelBegan career as a software and database developer at a small software firm.lDeveloped specialization in Microsoft BI offerings.lFocused on Oracle EPM, primarily Hyperion Essbase and Planning, with some HFM.lPresented at Kaleidoscope 2010, 2011, and now 2012 and various regional events.

#KscopeIntroduction -About US-Analytics"Focused and Committed"lDallas-based Industry Leaders, Pioneers and Trustworthy for 13 yearslFocused on enterprise performance management applicationslOver 50 professionals dedicated to EPM and BIlStrategic Oracle Partner and Oracle BI Pillar PartnerlAdvanced degrees and certifications (CPAs, CMAs, MBAs)lSeasoned Infrastructure practice: 400+ installations/migrations lUnique blend of deep technical expertise and business acumen with hundreds of implementation cycles, driven towards a results-oriented, customer ROIlStrong project leadership & proactive account managementlCorporate culture of integrity with 100% customer commitmentlFull Service Solution Provider

#KscopeIntroduction -About US-AnalyticsPerformance ApplicationsDesign and development of EPM and BI solutionsOperational InfrastructureInfrastructure design and installation servicesChange management, disaster recovery, load balancing, fail-overContinuity ServicesSpecialized Placement ServicesHelpdesk/Hotline supportEducation/Mentoring/"Expert-on-site"Software re-sellManaged ServiceslLeadership in Hyperion CommunityFounding sponsor of the Hyperion Women's ForumPresenters at the Kaleidoscope ConferenceSponsor of Dallas Hyperion User Group (HUG)

#KscopeAbout The DatalBuilt on Hyperion Essbase 11.1.2.2lSQL Server 2008 R2 Data SourcelMillions of members in the outline2.2 Million Customers132,000 ProductslHundreds of millions of rows of datalBenchmarks use a subset

#KscopeLarge Scale ASO ChallengeslLarge dimensionslLong restructure timeslLarge data setslSlow data loadslSlow query performancelLong running aggregation materialization

#KscopeLarge DimensionslHundreds of thousands or even millions of membersSku-level dataCustomer-level datalLarge dynamic dimensions will kill performance, so always make these stored where possibleMultiple Hierarchies are your friendlPartitions can help to break out dimensions that grow with timelThe more levels the better...Phone-book flat dimensions

#KscopeLong Restructure TimeslFirst the simple solution...deferred restructurelClearing data can be faster...sometimesCreates a slightly more complex processGreat for instances where you have to reload data anywaylPartitions will allow you to split the data out and limit the amount of data being restructuredNo Data•20 Seconds2GB Data•235 Seconds

#KscopeLarge Data SetslHow do we load large data sets efficiently?Parallel LoadsData Slices (incremental loads)No parallel loads supportedCreate multiple scripts to run in parallel with new slicesOptimize your Temp tablespace (more on this later)Partitions (yes, I keep mentioning this!)

#KscopeLarge Data Sets (Cont.)lEnabling SQL Parallel LoadsCreate this file: "C:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin\esssql.cfg"Use the DataDirectdriver for SQL[Description "DataDirect 6.1 SQL Server Wire Protocol"DriverName ARMSSS25UpperCaseConnection 0UserId 1Password 1Database 1SingleConnection 0IsQEDriver 0]

#KscopeLarge Data Sets (Cont.)lParallel Load PerformanceMaxLSQL Load Sample:Performance depends on your source too:import database ASODemo.ASODemo data connect as hyperion identified by 'password' using multiple rules_file 'dQ12011','dQ22011' to load_buffer_block starting with buffer_id 100 on error write to 'C:\Process\Logs\dQ1Q22011.err';One Thread•110 SecondsTwo Threads•141 SecondsFour Threads•240 Seconds

#KscopePartitionslWhy would I use partitions?Reduces the amount of data and meta-data that have to be touched for regular processesStill faster than slicesLets aggregations stick around for the majority of your dataHelps make better use of optimized hardwarelWhat do I partition by?Time or other predictable patterns of analysisData elements that will reduce the size of dimensions per partition

#KscopeAggregationslHow do we decide what to aggregate?Usage-based aggregationsSize-based aggregationsHint-based aggregationslWhat gets aggregated?Only stored dimensions are consideredDynamic dimensions will remain just that...dynamiclHow do we speed up aggregation buildsOptimize your hardware (more on this later)Partitions...so we don't have to rebuild them

#KscopeHardware OptimizationlThree Main FactorsCPU ThreadsMemoryHard DisklAs hardware gets cheaper, we start to throw more of it at EssbaseWithout the right settings, all that power means nothingDefault ASO settings use 2 CPU threads and 32mb of RAM...seriously...

#KscopeHardware Optimization (cont.)lSo I have a server with 64 threads, 256GB of RAM, and more hard drives than you can shake a stick at...now what?CALCPARALLELDefaults to 2 threads for ASO.New to 11.1.2.2, this can be set all the way to 128!Previously this maxed out at 8...sorry old versioners.Aggregate Storage CachePending Cache Size Limit (set per application)Defaults to 32mb...why not just set it to 128gb?

#KscopeHardware Optimization (cont.)lWhy not just set the CALCPARALLEL and cache settings all the way up?Your hard disks probably can't keep upIf you have 128gb of data processed in cache, it then needs to be committed to the temp tablespace(more on this later)When that data starts to get written, you start wasting CPU cyclesFind the balance!

#KscopeTablespaceslEvery ASO application will require at least two tablespacesDefault -The tablespacethat holds all of your data and aggregationsTemp -The tablespacewhere data is initially loaded before being committed to the default tablespacelHard drives are generally the weakest linkDefault and Temp should be on separate hard drives, raid arrays or HBAs (SAN cards).During the final commit, data is transferred from one to the other, so separate them

#KscopePutting it all together...lDeferred restructures to speed up dimension buildslParallel data loads to get large sets of data in fasterlPartitions to split data and meta-data into more than one cubelOptimize your server and application settings to make the best use of your hardware

#KscopeQ&A

#KscopeLarge Scale ASO: Making Essbase Silky Smooth with Terabytes of DataPlease fill out your evaluations!Brian MarshallUS-Analytics

quotesdbs_dbs15.pdfusesText_21