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
Product
Knowleg Base
Databases
Latest Activity
Q&A
Best Practices
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg 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
TOPICS
MEMBERS
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Tags
Search
Join this category to participate in conversations and receive notifications when new posts are added
JOIN
1
How to update the Pyramid repository server location
The following explains how to move the Pyramid repository location to another server if needed. You first need to stop the services to change your Pyramid repository location.…
Liran Levi
Pyramid Employee
Liran_Levi
6 days ago
5
1
Databases
0
How to add a CData custom connector as a data source
A step-by-step guide on how to add a CData custom connector as a data source. Download the Java JDBC driver for the data source you want to connect to. (Click here for a complete list of the…
Omer Ansher
Community Team
Omer_Ansher
1 mth ago
34
Databases
2
Data Connector Changes in 2020.24
As of version 2020.24, certain data connectors have been removed from the standard installation for various reasons (licensing/paywall). Going forward, these connectors can still be used,…
Yakov Shaul
Admin
Yakov_Shaul
8 mths ago
57
2
Databases
2
How to backup and restore a PostgreSQL database via DBeaver
This article discusses how to back up and restore your PostgreSQL database via DBeaver. There is another way to do it via the windows command line, as described in this article:…
Omer Ansher
Community Team
Omer_Ansher
updated
1 mth ago
7,613
2
Databases
0
How to connect SalesForce as a data source in Pyramid
In order to add SalesForce as a data source in Pyramid, you will need to set up an app in SF and use the Consumer Key and the Secret Key of the app. Please follow these steps in order to create the…
Omri Zach
Community Team
Omri_Zach
1 yr ago
33
Databases
2
Creating a test environment from a production repository
The following article will cover PostgresSQL, SQL, And Oracle databases. Postgres When using Postgres as the Pyramid repository, to create a copy of an existing environment,…
Liran Jorno
Pyramid Employee
Liran_Jorno
updated
1 mth ago
351
2
Databases
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
112
2
Databases
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
356
1
Databases
2
Routine Content Backup Recommendations
The following are items we Recommend backing up periodically. (Preferably Daily but it's up to you) The database repository. If you don't know where it is, browse to HTTP:…
Daniel
Admin
Daniel
updated
8 mths ago
229
2
Databases
1
How to hide Microsoft SQL databases that a user does not have access to
By default even if a user does not have access to an Microsoft SQL database they can still view it when logging into SQL Management studio. Therefore the same behavior will be seen in Pyramid when…
Daniel
Admin
Daniel
updated
1 mth ago
4,813
1
Databases
1
How to backup and restore a PostgreSQL database
Before upgrading Pyramid, it is strongly advised to take a backup before hand. If using the built in PostgreSQL for the Pyramid repository database below is how to backup and restore the database if…
Daniel
Admin
Daniel
updated
1 mth ago
2,037
1
Databases
0
Troubleshoot a failure when trying to creating a large IMDB model
When creating a new model to an "IMDB" data source, and the model looks like it is created, but it cannot be queried in Discover (the Green app) (An error is shown).…
Daniel
Admin
Daniel
updated
3 yrs ago
332
Databases
Members
View all members
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg 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
Pyramid Community User Survey
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help