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 likes
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
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
3 yrs ago
1,089
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
3 yrs ago
828
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
3 yrs ago
1,240
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 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
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 Wilmot
staff
Dan_Wilmot
3 yrs ago
619
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
3 yrs ago
1
reply
1,451
4
samuel alma
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
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
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
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
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
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
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
3 yrs ago
925
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
3 yrs ago
1,108
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 Wilmot
staff
Dan_Wilmot
3 yrs ago
450
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 Wilmot
staff
Dan_Wilmot
3 yrs ago
2
replies
890
3
Karen Owens
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
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
3 yrs ago
873
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 Picker
staff
Jason_Picker
3 yrs ago
2
replies
2,257
3
Yakov Shaul
3 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
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
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
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 Dermid
staff
Forrest_Dermid
3 yrs ago
967
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
3 yrs ago
896
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
3 yrs ago
829
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