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 views
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
Creating a Shapefile Using Latitude and Longitude Coordinates
by @Forrest Dermid , Senior Solutions Engineer Let’s walk through how to create a shapefile using latitude and longitude coordinates. We’ll use QGis for the shapefile and Pyramid Analytics’ BI…
Karen Owens
Karen_Owens
3 yrs ago
6,319
BI Office Blogs
Tableau – An Incomplete Choice for Microsoft Analysis Services
By Michael Raam , Principal Data Analytics, Pyramid Analytics Tableau connects to many data sources, including Analysis Services (SSAS). What isn’t widely known though,…
John Hormaechea
Director, Product Marketing
John_Hormaechea
3 yrs ago
4,225
2
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
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
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
3 yrs ago
2,089
3
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
Time Intelligence Wizard – Part 1 (Attribute Hierarchies)
By David Novick - Technical Writer, Pyramid Analytics If you haven’t yet worked with the Time Intelligence (TI) Wizard, this blog series is meant for you. First introduced in BI Office 6.…
David Novick
Technical Writer
David_Novick
3 yrs ago
1,921
2
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
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
SSAS KPIs in BI Office
By David Novick, Pyramid Analytics Technical Writer This blog provides a quick introduction to the usage of SQL Server Analysis Services (SSAS) KPIs within BI Office.…
David Novick
Technical Writer
David_Novick
3 yrs ago
1,762
1
BI Office Blogs
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
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 Custom Waterfall Charts in BI Office
@Ian Macdonald , Principal Technologist, Pyramid Analytics A waterfall chart is a special type of column chart which is normally used to demonstrate how the starting position either increases or…
Karen Owens
Karen_Owens
3 yrs ago
1,577
2
BI Office Blogs
Dynamic Banding in Custom KPIs - Part 2 (Evaluation Sets)
By David Novick, Pyramid Analytics Technical Writer When designing Custom KPIs in BI Office, an innovative feature called dynamic banding helps you optimize runtime gauge display.…
David Novick
Technical Writer
David_Novick
3 yrs ago
1,520
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
Dynamic Banding in Custom KPIs - Part 1 (Intro)
By David Novick, Pyramid Analytics Technical Writer What is Dynamic Banding? When designing Custom KPIs in BI Office, a powerful feature called "dynamic banding" allows you to pre-configure KPI…
David Novick
Technical Writer
David_Novick
3 yrs ago
1,428
BI Office Blogs
Time Intelligence Wizard – Part 3 (Parameterization)
by David Novick, Pyramid Analytics Technical Writer Parameters are one of those smart BI Office features that help you deliver powerful business graphics with just a few clicks of your mouse.…
David Novick
Technical Writer
David_Novick
3 yrs ago
1,421
BI Office Blogs
Dynamic Banding in Custom KPIs - Part 3 (Variables)
by David Novick, Pyramid Analytics Technical Writer Part 3 in this blog series presents an example involving the use of variables for the definition of Custom KPI band endpoints.…
David Novick
Technical Writer
David_Novick
3 yrs ago
1,414
1
BI Office Blogs
Conditional Formatting on Charts
by @Michael Raam , Principal Data Analytics - Pyramid Analytics Quite often there is a need to present a chart then cannot be found simply in the point-and-click menus within BI Office.…
Michael Raam
Michael_Raam
3 yrs ago
1,386
1
BI Office Blogs
Custom Visuals in Pyramid Analytics
by @Michael Raam , Principal Data Analytics and Mark Khoroshansky, Development Pyramid Analytics provides a wide range of data-driven visualizations. However,…
Michael Raam
Michael_Raam
3 yrs ago
1,371
1
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
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
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
Using Interactions to Open a New Web Page
by Ian Macdonald , Principal Technologist - Pyramid Analytics Background One of my customers recently asked if they could open a BI Office storyboard from an interaction on a row or column heading…
Ian Macdonald
Admin
Principal Technologist
Ian_Macdonald
3 yrs ago
1,286
2
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