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

Cascading Prompts: Making your reports more dynamic
by @Kenny Rencher , Technical Product Marketing Slicers are a great way to make everything in your report dynamic. Parameterizing your members and creating sets is another great way to make your…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 8 replies
- 1,761
- 1
- Nikos Volakakis2 yrs ago
- BI Office Blogs
Best Practices When Upgrading BI Office
BI Office upgrades are a very straight forward process. But there are checks that should be done after any software upgrade to ensure a smooth transition for your users.…
- John Hormaechea
- Director, Product Marketing
- John_Hormaechea
- 3 yrs ago
- 5 replies
- 1,738
- 2
- Jason Pickerstaff4 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
- 3 yrs ago
- 5 replies
- 1,827
- 4
- Tim AndrewsValued Beta Tester4 yrs 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
- 3 yrs ago
- 4 replies
- 984
- 2
- Giovanni Mejia2 yrs 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
- 3 yrs ago
- 4 replies
- 1,303
- 3
- Edward3 yrs ago
- 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
- 3 yrs ago
- 4 replies
- 1,310
- 4
- Tim AndrewsValued Beta Tester3 yrs ago
- BI Office Blogs
Setting Up Grid Images
by Forrest Dermid , Senior Sales Engineer Have you ever wondered how to include the image of a product alongside the SKU? How about the photo of a property that is under analysis?…
- Forrest Dermidstaff
- Forrest_Dermid
- 3 yrs ago
- 4 replies
- 945
- 1
- Ian MacdonaldAdmin3 yrs 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
- 3 yrs ago
- 3 replies
- 1,732
- 3
- Avi PerezAdmin2 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
- 3 yrs ago
- 2 replies
- 1,136
- 2
- Alister Hill1 yr 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
- 3 yrs ago
- 2 replies
- 1,941
- 3
- Danielstaff2 yrs ago
- BI Office Blogs
Simple Modeling for Everyone Using Cell Overlay
by @John Hormaechea , Director of Product Marketing at Pyramid Analytics Customers often ask “can you change that value for cost allocations” or “I want to set up custom calculation that performs an…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 2 replies
- 1,153
- John Hormaechea3 yrs ago
- 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
- 3 yrs ago
- 2 replies
- 890
- 3
- Karen Owens4 yrs ago
- 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
- 3 yrs ago
- 2 replies
- 2,257
- 3
- Yakov Shaul3 yrs ago
- BI Office Blogs
GIS engine change following discontinued Bing Maps Silverlight Control
Geospatial upgrades BI Office Versions 5.6 and 6.3 On November 30, 2016, Microsoft is deprecating key Bing mapping functionality, the primary source of geospatial data found in BI Office.…
- John Hormaechea
- Director, Product Marketing
- John_Hormaechea
- 3 yrs ago
- 2 replies
- 1,884
- John Hormaechea4 yrs 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
- 3 yrs ago
- 1 reply
- 2,689
- 3
- Carmelita Resh2 yrs ago
- BI Office Blogs
How to Create a Date Calculation Column in Tabular Models
by @Jason Picker , Senior Sales Engineer, Pyramid Analytics This video shows how to use BI Office to add a Date Calculations attribute to a Tabular model in order to provide flexible time-dynamic…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 1 reply
- 1,108
- Tim AndrewsValued Beta Tester3 yrs 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
- 3 yrs ago
- 1 reply
- 1,212
- 2
- Tim AndrewsValued Beta Tester3 yrs ago
- BI Office Blogs
Dynamic Top Count Filters Using Variables and Parameters
By @Jason Picker , Sales Engineer Top Count filters are easy to implement using the Quick Filter menu available off the right-click menu. However, there are times you need to create something more…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 1 reply
- 976
- 2
- Tim AndrewsValued Beta Tester3 yrs ago
- BI Office Blogs
Distance-Based Geo Analysis
by Michael Raam, Principal Data Analytics, Pyramid Analytics and David Novick, Technical Writer, Pyramid Analytics In the world of data analytics, one of the primary usages of maps is to perform…
- Michael Raam
- Michael_Raam
- 3 yrs ago
- 1 reply
- 1,252
- 2
- Tim Gray3 yrs ago
- 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
- 3 yrs ago
- 1 reply
- 1,451
- 4
- samuel alma4 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
- 3 yrs ago
- 1 reply
- 979
- 3
- samuel alma3 yrs ago
- BI Office Blogs
Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics' BI Office
by Matt Burr , Senior Solutions Engineer at Pyramid Analytics Someone asked recently, “Does Pyramid Analytics support DirectQuery in SQL Server Analysis Services?” The short answer is, “Yes!…
- Matt Burrstaff
- Matt_Burr
- 3 yrs ago
- 1 reply
- 1,364
- 1
- Peter Sprague4 yrs ago
- BI Office Blogs
Advanced Dashboards Vlog - Part 1
In BI Office's Story Board, users can create impressive, attractive dashboards such as those in this four-part video blog. This vlog shows version 5; however,…
- Karen Owens
- Karen_Owens
- 2 yrs ago
- 691
- 1
- BI Office Blogs
Creating Big Lists Quickly
by @John Hormaechea , Director, Product Marketing at Pyramid Analytics When I was a presales engineer I’d come across a number of customer requests. One common one was how do I quickly create a set…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 1,255
- 1
- BI Office Blogs
Axis of Awesome
by @Jason Picker, Senior Sales Engineer In your high school history class, you may have learned about the Axis of Evil, but have you heard about the Axis of Awesome?…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 851
- 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

Cascading Prompts: Making your reports more dynamic

Best Practices When Upgrading BI Office

Cluster Charts

Dynamic Eliminations

MDX-Driven Paging Mechanism

Best Practices for BI Office from Tim Andrews

Setting Up Grid Images

Applying R to Text Analytics

Creating Running Totals/Partial Sums in BI Office

Editing of KPI Gauges

Simple Modeling for Everyone Using Cell Overlay

Variable Search Dashboards Vlog - Part 2

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

GIS engine change following discontinued Bing Maps Silverlight Control

Formatting Time Duration

How to Create a Date Calculation Column in Tabular Models

How to Personalize User Preferences on Storyboard Slicers

Dynamic Top Count Filters Using Variables and Parameters

Distance-Based Geo Analysis

Clustering with Mixed Data Types

BI Office Query Speed Optimization

Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics' BI Office

Advanced Dashboards Vlog - Part 1

Creating Big Lists Quickly

Axis of Awesome

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources