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
Tags
MDX
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
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
updated
4 mths ago
845
5
BI Office Blogs
Troubleshooting MDX Related Issues Using the SQL Profiler
The SQL Profiler is an excellent tool to troubleshoot query related issues. Using the profiler, you can analyze the queries run by Pyramid, find query duration times in SSAS and compare it with the…
updated
11 mths ago
713
General Issues
2
Retrieving XMLA to analyze cube structure
Below are instructions on how to get the cube structure (dimensions, hierarchies, measures…) It can help the Pyramid development team debug cases where the query fails to get the cube metadata.…
Yakov Shaul
Admin
Yakov_Shaul
2 yrs ago
137
2
Databases
0
Custom MDX queries
Hi Team, The product is fantastic and lot of options where we need to have explore on periodically. In pyramid 2018 we want to write the custom MDX queries.…
Rama Krishna B
Rama_Krishna_B
updated
5 yrs ago
3
replies
175
Last reply
Rama Krishna B
5 yrs ago
Q&A
Answered
Answered
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,325
3
Last reply
Edward
5 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
updated
5 yrs ago
1,944
2
BI Office Blogs
Scrolling & Paging in Long Grids
by Michael Raam, Principal Data Analytics, Pyramid Analytics and David Novick, Technical Writer, Pyramid Analytics Challenged by a monster grid? Overwhelmed by a mile long scroll bar?…
Michael Raam
Michael_Raam
updated
5 yrs ago
1,073
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
Community Team
Matt_Burr
updated
5 yrs ago
1
reply
1,433
1
Last reply
Peter Sprague
6 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
Community Team
Jason_Picker
updated
5 yrs ago
2
replies
2,305
3
Last reply
Yakov Shaul
Admin
5 yrs ago
BI Office Blogs
Home
Q&A
Best Practices
Learning Live Archive
Learning Live Topic Suggestions
Tips & Tricks
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge 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
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help