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
query
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
0
How to create a report without live connection?
Hi We are looking at creating some reports (in publish) that we would only want to refresh once a week. In this way we are trying to find a way to create some type of saved report that would save…
Yakov Shor
Top Contributor
Yakov_Shor
6 mths ago
4
replies
44
Last reply
Yakov Shor
Top Contributor
4 mths ago
Q&A
Answered
Answered
1
Error using an OLAP connection: "The 'MSOLAP' provider is not registered on the local machine..."
This error can occur when trying to run a query while the underlying data source is MS OLAP. The error indicates that the msolap130.dll file is not registered in the Pyramid environment.…
Itamar Birenzweig
Admin
Itamar_Birenzweig
updated
1 yr ago
431
1
Databases
4
What is a "Subquery mode" ?
Note: "Sub Query" mode is only applicable to Microsoft Analysis Services data sources. Microsoft SSAS has a limitation that the "where" clause of the MDX statement can't accept more than one element…
Daniel
Admin
Daniel
updated
1 yr ago
80
4
Performance
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
Question on row sorting
I'm converting a BI Office chart. It's laid out like this: Slices - a date parameter at the month level Columns - Two date calculated members that I have defined in my cube (Current Period and Prior…
Tim Andrews
Business Intelligence Manager
Tim_Andrews
4 yrs ago
1
reply
53
Last reply
ez
Pyramid Employee
3 yrs ago
Q&A
Answered
Answered
1
Multiple Members Search
Is it possible to do a multiple Members Search in Pyramid 2018 as it was in BI Office? As you can see in the first example, I'm searching using barcodes to find the members but when I try the same…
Jamie Allcock
Jamie_Allcock
3 yrs ago
3
replies
21
1
Last reply
Avi Perez
Admin
3 yrs ago
Q&A
Answered
Answered
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
updated
5 yrs ago
1
reply
985
3
Last reply
samuel alma
6 yrs ago
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
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