How to enable Javascript

SQL

Change SQL ConnectionString to BI Office repository
Change SQL ConnectionString to BI Office repository Case: SQL User/PSW has changed. Or you need to move your BI Office repository. Symptoms: Services aren’t coming up.…
- 2 mths ago
- 1,218
- SQL Issues
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
- 1 yr ago
- 201
- Databases
Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics BI Office (Part 2): Living Without User-Defined Hierarchies
by Matt Burr , Senior Solutions Engineer at Pyramid Analytics In a previous blog post , we saw that while BI Office works with SQL Server Analysis Services (SSAS) tabular models in DirectQuery mode,…
- Matt Burrstaff
- Matt_Burr
- 2 yrs ago
- 479
- 1
- 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 Burrstaff
- Matt_Burr
- 2 yrs ago
- 1 reply
- 1,349
- 1
- Peter Sprague3 yrs ago
- BI Office Blogs
0
Database Connection Error: There Was an Error Connecting to the Database
Issue: Getting an error message saying Database Connection Error: There was an error connecting to the database when running the Pyramid Deployment Wizard.…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 1,341
- Installations
Pyramid Connects Only to SQL 2005 Cubes, Service Pack 4 and Up
First Problem : ‘ Object was not found ’ error while trying to connect to perspective cube on SSAS 2005 if you are running SQL 2005 SP3 or earlier When Cube is not visible,…
- 3 yrs ago
- 627
- SQL Issues
Unable to Connect to a Data Source Using a '.' as the Hostname/IP in BI Office 5.
In BI Office 5, if a data source is defined as '.', it may fail. This is currently by design. The following workarounds can be used to overcome this: Switch the datasource from .…
- 3 yrs ago
- 607
- SQL Issues
Server Collation MUST Be Case Insensitive
Problem description: Not all Pyramid database scripts has run successfully, this will throw an error at the end of the configuration stage but will, but after this message it will seem to finish…
- 3 yrs ago
- 656
- SQL Issues
On Installation, You Can Only Use Server Authentication When Setting the Pyramid Repository
During the installation process,Do not select ‘Windows Authentication’ for the SQL server authentication. You can only select the Server authentication option.…
- 3 yrs ago
- 559
- SQL Issues

SQL

Change SQL ConnectionString to BI Office repository

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

Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics BI Office (Part 2): Living Without User-Defined Hierarchies

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

Database Connection Error: There Was an Error Connecting to the Database

Pyramid Connects Only to SQL 2005 Cubes, Service Pack 4 and Up

Unable to Connect to a Data Source Using a '.' as the Hostname/IP in BI Office 5.

Server Collation MUST Be Case Insensitive

On Installation, You Can Only Use Server Authentication When Setting the Pyramid Repository

Categories

Tags

Top contributors

Recent activity

Recent Tweets

Home

Tags

Key Resources