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
- 8 mths ago
- 4replies
- 49
- Last replyYakov ShorTop Contributor7 mths 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 AllcockCustomer
- Jamie_Allcock
- 3 yrs ago
- 3replies
- 22
- 1
- Last replyAvi PerezAdmin3 yrs ago
- Q&A
- Answered
- Answered
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
- 5 yrs ago
- 1reply
- 54
- Last replyezPyramid Employee3 yrs 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
- 514
- 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 2 yrs ago
- 85
- 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
- 151
- 2
- Databases

Welcome to the community!

User Community

query

How to create a report without live connection?

Multiple Members Search

Question on row sorting

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

Home

Key Resources