How to enable Javascript

MDX

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 ShaulAdmin
- 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
- 3replies
- 175
- Last replyRama Krishna B5 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
- 4replies
- 1,325
- 3
- Last replyEdward5 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 BurrCommunity Team
- Matt_Burr
- updated 5 yrs ago
- 1reply
- 1,433
- 1
- Last replyPeter Sprague6 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 PickerCommunity Team
- Jason_Picker
- updated 5 yrs ago
- 2replies
- 2,305
- 3
- Last replyYakov ShaulAdmin5 yrs ago
- BI Office Blogs

Welcome to the community!

User Community

MDX

Making the GENERATE Statement Easy Using N-of-N

Troubleshooting MDX Related Issues Using the SQL Profiler

Retrieving XMLA to analyze cube structure

Custom MDX queries

MDX-Driven Paging Mechanism

Time Intelligence Wizard – Part 1 (Attribute Hierarchies)

Scrolling & Paging in Long Grids

Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics' BI Office

Passing Multiple-Select Parameters from BI Office to SQL Server Reporting Services

Home

Key Resources