How to enable Javascript

BI Office Blogs

Posts on advanced techniques in BI Office.

TOPICS MEMBERS

Join this category to participate in conversations and receive notifications when new posts are added.

JOIN

Join

Choosing a Forecasting Algorithm
by Bar Amit, Data Scientist, Pyramid Analytics and David Novick Technical Writer, Pyramid Analytics New Trends Demand Smart Reactions In most management decisions made in today's busy world,…
- Bar Amit
- Bar_Amit
- 2 yrs ago
- 1,069
- 6
- BI Office Blogs
Making the GENERATE Statement Easy Using N-of-N
by John Hormaechea , Director, Product Marketing at Pyramid Analytics Generally, creating top counts is easy using the filtering capability in BI Office.…
- John Hormaechea
- Director, Product Marketing
- John_Hormaechea
- 2 yrs ago
- 820
- 5
- BI Office Blogs
SSAS Cube Action Enhancements
With the new version 6.40 of BI Office, we offer enhanced support for SSAS actions (DrillThrough and Row set) plus support for a new action: ' Proprietary '.…
- Michael Raam
- Michael_Raam
- 2 yrs ago
- 1,226
- 4
- BI Office Blogs
Best Practices for BI Office from Tim Andrews
@Tim Andrews is one of our most active users in the community. We asked him to share some tips with you to help you make the most of BI Office. As a daily user of BI Office for the past two years,…
- Tim AndrewsValued Beta Tester
- Business Intelligence Manager
- Tim_Andrews
- 2 yrs ago
- 4 replies
- 1,302
- 4
- Tim AndrewsValued Beta Tester2 yrs ago
- BI Office Blogs
Variable Search Dashboards Vlog - Part 1
by Dan Wilmot , Senior Architect Have you ever struggled with getting exactly what you wanted from a dashboard or visualization? In this three part video blog,…
- Dan Wilmotstaff
- Dan_Wilmot
- 2 yrs ago
- 618
- 4
- BI Office Blogs
Clustering with Mixed Data Types
by David Novick, Technical Writer, Pyramid Analytics and Bar Amit, Data Scientist, Pyramid Analytics Clustering algorithms typically create groups based on homogeneous data which can be either…
- David Novick
- Technical Writer
- David_Novick
- 2 yrs ago
- 1 reply
- 1,436
- 4
- samuel alma3 yrs ago
- BI Office Blogs
Cluster Charts
by @Michael Raam , Principal Data Analytics - Pyramid Analytics As machine learning is becoming more and more widespread within the BI community there is a greater need to allow easy / non-technical…
- Michael Raam
- Michael_Raam
- 2 yrs ago
- 5 replies
- 1,822
- 4
- Tim AndrewsValued Beta Tester3 yrs ago
- BI Office Blogs
Editing of KPI Gauges
By David Novick, Pyramid Analytics Technical Writer This blog describes how to edit KPI gauges within BI Office. These instructions apply to both SSAS KPIs in BI Office and Custom KPIs in BI Office .…
- David Novick
- Technical Writer
- David_Novick
- 2 yrs ago
- 2 replies
- 1,913
- 3
- Danielstaff1 yr ago
- BI Office Blogs
Applying R to Text Analytics
by @Michael Raam , Principal Data Analytics - Pyramid Analytics and @Bar Amit Data Scientist - Pyramid Analytics As machine learning becomes more popular we are asked how Pyramid Analytics can…
- Michael Raam
- Michael_Raam
- 2 yrs ago
- 3 replies
- 1,727
- 3
- Avi PerezAdmin1 yr ago
- BI Office Blogs
Formatting Time Duration
by @Ian Macdonald, Principal Technologist, Pyramid Analytics In many analytic applications, we may want to analyse and display the duration of activities.…
- Karen Owens
- Karen_Owens
- 2 yrs ago
- 1 reply
- 2,670
- 3
- Carmelita Resh1 yr ago
- BI Office Blogs
MDX-Driven Paging Mechanism
By @Michael Raam , Principal, Data Analytics This short blog provides how to create a MDX-driven paging mechanism for easy navigation through long tables.…
- Michael Raam
- Michael_Raam
- 2 yrs ago
- 4 replies
- 1,287
- 3
- Edward2 yrs ago
- BI Office Blogs
Introduction to Publications - Part 1
BI Office Publications are a rich way to share business insights. In this three part vlog, Jenn defines the value found in Publisher so you can understand how your business will benefit from dynamic,…
- Karen Owens
- Karen_Owens
- 2 yrs ago
- 915
- 3
- BI Office Blogs
Using SSAS ‘Proprietary’ Cube Actions with BI Office API
The new BI Office GetActionData API function (v6.40) is an advanced feature designed to allow customization and advance integration of BI Office, Analysis Services with 3rd party web applications.…
- Michael Raam
- Michael_Raam
- 2 yrs ago
- 1,100
- 3
- BI Office Blogs
Variable Search Dashboards Vlog - Part 3
by @Dan Wilmot , Senior Architect Have you ever struggled with getting exactly what you wanted from a dashboard or visualization? In this three part video blog,…
- Dan Wilmotstaff
- Dan_Wilmot
- 2 yrs ago
- 448
- 3
- BI Office Blogs
Variable Search Dashboards Vlog - Part 2
by Dan Wilmot , Senior Architect Have you ever struggled with getting exactly what you wanted from a dashboard or visualization? In this three part video blog,…
- Dan Wilmotstaff
- Dan_Wilmot
- 2 yrs ago
- 2 replies
- 888
- 3
- Karen Owens3 yrs ago
- BI Office Blogs
BI Office Query Speed Optimization
by the Pyramid Analytics’ Dev Team Overview Given the vast number of query formations possible with MDX, together with the almost endless cube designs and calculation combinations available,…
- Karen Owens
- Karen_Owens
- 2 yrs ago
- 1 reply
- 975
- 3
- samuel alma3 yrs ago
- BI Office Blogs
SAP Integration: BI Office Version 6.3
Jennifer Dorothea , Senior Product Marketer SAP is an industry leading provider of enterprise application software. Business users have come to rely on SAP’s technologies from supply chain to…
- Jennifer Dorothea
- Senior Product Marketer
- Jennifer_Dorothea
- 2 yrs ago
- 868
- 3
- BI Office Blogs
Passing Multiple-Select Parameters from BI Office to SQL Server Reporting Services
by Jason Picker , Sales Engineer Pyramid Analytics There are two primary ways to pass multi-select parameters to SQL Server Reporting Services (SSRS): using standard BI Office parameters or using…
- Jason Pickerstaff
- Jason_Picker
- 2 yrs ago
- 2 replies
- 2,227
- 3
- Yakov Shaul2 yrs ago
- BI Office Blogs
Creating Running Totals/Partial Sums in BI Office
by Sandesh Nagaraj , Senior Sales Engineer What is Running Total/Partial Sum? A running total is the summation of a column of values which is updated each time a new row is added to the grid or…
- Sandesh Nagarajstaff
- Sandesh_Nagaraj
- 2 yrs ago
- 2 replies
- 1,105
- 2
- Alister Hill5 mths ago
- BI Office Blogs
Dynamic Eliminations
by Ian Macdonald , Principal Technologist Background One of the ways BI Office is unique in fronting Analysis Services is its ability to create “asymmetric grids”.…
- Ian MacdonaldAdmin
- Principal Technologist
- Ian_Macdonald
- 2 yrs ago
- 4 replies
- 964
- 2
- Giovanni Mejia1 yr ago
- BI Office Blogs
How to Personalize User Preferences on Storyboard Slicers
A common request form customers is the ability to personalize a dashboard for each user. This is similar to dynamic security but different in that instead of limiting the slicer values to those a…
- Jason Pickerstaff
- Jason_Picker
- 2 yrs ago
- 1 reply
- 1,203
- 2
- Tim AndrewsValued Beta Tester2 yrs ago
- BI Office Blogs
Custom KPIs in BI Office
By David Novick, Pyramid Analytics Technical Writer In today’s performance driven world, the use of Key Performance Indicators (KPIs) is becoming increasingly popular throughout all business sectors.…
- David Novick
- Technical Writer
- David_Novick
- 2 yrs ago
- 2,055
- 2
- BI Office Blogs
BubbleUp Exceptions
by @Forrest Dermid , Sr. Solutions Engineer, Pyramid Analytics Objective of Document: Explore one approach using a calculation to identify at the lowest level in the Microsoft SQL Server Analysis…
- Forrest Dermidstaff
- Forrest_Dermid
- 2 yrs ago
- 953
- 2
- BI Office Blogs
Effective Dashboard Design Vlog - Part 1
BI Office Story Board makes presenting your business insights easy. However, designing a dashboard can be difficult as there are many levels to making it effective.…
- Karen Owens
- Karen_Owens
- 2 yrs ago
- 887
- 2
- BI Office Blogs
Clustering and Plotting All Observations in BI Office 6
@Tim Andrews , timandrews1@gmail.com I recently watched John Hormaechea’s webinar where he taught us how to use R functionality within BI Office. I had not found the time to fully explore the BI…
- Karen Owens
- Karen_Owens
- 2 yrs ago
- 827
- 2
- BI Office Blogs

1 2 3 4 Next

Posts on advanced techniques in BI Office.

Members

View members

Recent Tweets

Follow @PyramidAnalytic

BI Office Blogs

Choosing a Forecasting Algorithm

Making the GENERATE Statement Easy Using N-of-N

SSAS Cube Action Enhancements

Best Practices for BI Office from Tim Andrews

Variable Search Dashboards Vlog - Part 1

Clustering with Mixed Data Types

Cluster Charts

Editing of KPI Gauges

Applying R to Text Analytics

Formatting Time Duration

MDX-Driven Paging Mechanism

Introduction to Publications - Part 1

Using SSAS ‘Proprietary’ Cube Actions with BI Office API

Variable Search Dashboards Vlog - Part 3

Variable Search Dashboards Vlog - Part 2

BI Office Query Speed Optimization

SAP Integration: BI Office Version 6.3

Passing Multiple-Select Parameters from BI Office to SQL Server Reporting Services

Creating Running Totals/Partial Sums in BI Office

Dynamic Eliminations

How to Personalize User Preferences on Storyboard Slicers

Custom KPIs in BI Office

BubbleUp Exceptions

Effective Dashboard Design Vlog - Part 1

Clustering and Plotting All Observations in BI Office 6

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources