Pyramid
Solutions
Learn
Company
Pyramid Analytics
User Community
How to enable Javascript
Sign Up
Login
Home
BI Office
BI Office Blogs
Posts on advanced techniques in BI Office.
TOPICS
MEMBERS
Filter
Newest
Active
Most replies
Clear sort
Most likes
Most replies
Most views
Tags
Clear filter
Search
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 Volakakis
2 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 Picker
staff
4 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 Andrews
Valued Beta Tester
4 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 Macdonald
Admin
Principal Technologist
Ian_Macdonald
3 yrs ago
4
replies
984
2
Giovanni Mejia
2 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
Edward
3 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 Andrews
Valued Beta Tester
Business Intelligence Manager
Tim_Andrews
3 yrs ago
4
replies
1,310
4
Tim Andrews
Valued Beta Tester
3 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 Dermid
staff
Forrest_Dermid
3 yrs ago
4
replies
945
1
Ian Macdonald
Admin
3 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 Perez
Admin
2 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 Nagaraj
staff
Sandesh_Nagaraj
3 yrs ago
2
replies
1,136
2
Alister Hill
1 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
Daniel
staff
2 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 Hormaechea
3 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 Wilmot
staff
Dan_Wilmot
3 yrs ago
2
replies
890
3
Karen Owens
4 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 Picker
staff
Jason_Picker
3 yrs ago
2
replies
2,257
3
Yakov Shaul
3 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 Hormaechea
4 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 Resh
2 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 Andrews
Valued Beta Tester
3 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 Picker
staff
Jason_Picker
3 yrs ago
1
reply
1,212
2
Tim Andrews
Valued Beta Tester
3 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 Andrews
Valued Beta Tester
3 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 Gray
3 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 alma
4 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 alma
3 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 Burr
staff
Matt_Burr
3 yrs ago
1
reply
1,364
1
Peter Sprague
4 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
Categories
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Recent Tweets
Follow @PyramidAnalytic
Home
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Key Resources
Community Tour
Register for Training Webinars
Newsletters, Events, and Webinars
Learning Resources
Pyramid Tutorial Videos
Pyramid Help
Getting Started with Pyramid
BI Office
BI Office Help