User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Product
BI Office
BI Office Blogs
Latest Activity
Q&A
Best Practices
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
Posts on advanced techniques in BI Office.
TOPICS
MEMBERS
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Tags
Search
Join this category to participate in conversations and receive notifications when new posts are added
JOIN
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
updated
5 yrs ago
1
reply
2,715
3
Last reply
Carmelita Resh
4 yrs ago
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
updated
5 yrs ago
1,264
1
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
updated
5 yrs ago
2
replies
1,161
Last reply
John Hormaechea
5 yrs ago
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
updated
5 yrs ago
879
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
updated
3 mths ago
1,421
1
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
updated
5 yrs ago
1
reply
1,138
Last reply
Tim Andrews
5 yrs ago
BI Office Blogs
Advanced What-If Analysis
Today's tech blog revisits one of my personal favorites: What-If Analysis. Dan is a great presenter and teaches you how to take your analysis to the next level with advanced what-if analysis.…
Karen Owens
Karen_Owens
updated
5 yrs ago
714
1
BI Office Blogs
What Visualization Do I Use When?
We're revisiting this webinar which will explore various data visualizations, such as, grids, charts, gauges and advanced visualizations, and discuss how users can select the appropriate…
Karen Owens
Karen_Owens
updated
5 yrs ago
539
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
updated
5 yrs ago
1,525
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
updated
5 yrs ago
1,436
BI Office Blogs
Configuring Pyramid Analytics BI Office for Disaster Recovery
by @Joey Pruett , Presales Engineer and IT, Pyramid Analytics Introduction Pyramid Analytics BI Office is a highly available, enterprise-level BI suite that offers best-in-class performance and…
Karen Owens
Karen_Owens
updated
5 yrs ago
1,185
1
BI Office Blogs
Creating Jittered Scatterplots in BI Office 6
by @Tim Andrews , Power User of BI Office When tasked with visualizing a relationship between a continuous and more discrete variable, a jittered scatterplot can be a necessary evil.…
Karen Owens
Karen_Owens
updated
5 yrs ago
800
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
updated
5 yrs ago
8
replies
1,795
1
Last reply
Nikos Volakakis
5 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
Community Team
Jason_Picker
updated
5 yrs ago
1
reply
1,223
2
Last reply
Tim Andrews
5 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
updated
5 yrs ago
2,106
3
BI Office Blogs
Integrating Pyramid Analytics with Other Content
by @John Hormaechea , Director of Product Marketing, Pyramid Analytics Customers often have questions on how to integrate BI Office within other containers.…
Karen Owens
Karen_Owens
updated
5 yrs ago
912
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
Community Team
Forrest_Dermid
updated
5 yrs ago
975
2
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
updated
5 yrs ago
2
replies
1,971
3
Last reply
Daniel
Admin
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
updated
5 yrs ago
1,766
1
BI Office Blogs
Effective Dashboards Vlog - Part 3
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
updated
5 yrs ago
646
BI Office Blogs
Effective Dashboard Design Vlog - Part 2
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
updated
5 yrs ago
809
1
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
updated
5 yrs ago
905
2
BI Office Blogs
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
updated
3 mths ago
7,039
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
updated
3 mths ago
840
2
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
updated
5 yrs ago
4
replies
1,318
3
Last reply
Edward
5 yrs ago
BI Office Blogs
1
2
3
4
Next
Posts on advanced techniques in BI Office.
Members
View all members
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Pyramid Community User Survey
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help