Pyramid
Solutions
Learn
Company
Pyramid Analytics
User Community
How to enable Javascript
Sign Up
Login
Home
Pyramid
Technical Solutions
Databases
TOPICS
MEMBERS
Filter
Newest
Active
Most replies
Clear sort
Most likes
Most replies
Most views
Tags
Clear filter
Search
Join this category to participate in conversations and receive notifications when new posts are added.
JOIN
0
Creating a test environment from a production repository
The following article will cover PostgresSQL, SQL, And Oracle databases. Postgres For Postgres, you will need to confirm your Pyramid version on the Production environment by clicking on your…
Liran Jorno
staff
Liran_Jorno
3 mths ago
64
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
staff
Daniel
4 mths ago
848
1
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
Yakov_Shaul
5 mths ago
34
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
1 yr ago
98
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
staff
Daniel
1 yr ago
318
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
staff
Daniel
1 yr ago
127
2
Databases
0
How to hide SQL databases that a user does not have access to
By default even if a user does not have access to an SQL database they can still view it when logging into SQL Management studio. Therefore the same behaviour will be seen in Pyramid when connecting…
Daniel
staff
Daniel
2 yrs ago
582
Databases
Members
View members
Categories
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Recent Tweets
Follow @PyramidAnalytic
Home
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Key Resources
Community Tour
Register for Training Webinars
Newsletters, Events, and Webinars
Learning Resources
Pyramid Tutorial Videos
Pyramid Help
Getting Started with Pyramid
BI Office
BI Office Help