How to enable Javascript

Databases

TOPICS MEMBERS

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 Jornostaff
- 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…
- Danielstaff
- 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 BirenzweigAdmin
- 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).…
- Danielstaff
- 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:…
- Danielstaff
- 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…
- Danielstaff
- Daniel
- 2 yrs ago
- 582
- Databases

Members

View members

Recent Tweets

Follow @PyramidAnalytic

Databases

Creating a test environment from a production repository

How to backup and restore a PostgreSQL database

Retrieving XMLA to analyze cube structure

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

Troubleshoot a failure when trying to creating a large IMDB model

Routine Content Backup Recommendations

How to hide SQL databases that a user does not have access to

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources