How to enable Javascript

query

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 ShorTop Contributor
- Yakov_Shor
- 6 mths ago
- 4replies
- 44
- Last replyYakov ShorTop Contributor4 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 BirenzweigAdmin
- 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…
- DanielAdmin
- 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 ShaulAdmin
- 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
- 1reply
- 53
- Last replyezPyramid Employee3 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
- 3replies
- 21
- 1
- Last replyAvi PerezAdmin3 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
- 1reply
- 985
- 3
- Last replysamuel alma6 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 BurrCommunity Team
- Matt_Burr
- updated 5 yrs ago
- 1reply
- 1,433
- 1
- Last replyPeter Sprague6 yrs ago
- BI Office Blogs

Welcome to the community!

User Community

query

How to create a report without live connection?

Error using an OLAP connection: "The 'MSOLAP' provider is not registered on the local machine..."

What is a "Subquery mode" ?

Retrieving XMLA to analyze cube structure

Question on row sorting

Multiple Members Search

BI Office Query Speed Optimization

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

Home

Key Resources