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.…
- updated 2 yrs ago
- 1,275
- SQL Issues
0
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- chris
- Chris.1
- updated 3 yrs ago
- 5replies
- 51
- Last replyrajramesh nalla3 yrs ago
- Q&A
- Answered
- Answered
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…
- DanielAdmin
- Daniel
- updated 4 wk ago
- 4,450
- 1
- 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 BurrCommunity Team
- Matt_Burr
- updated 5 yrs ago
- 498
- 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 BurrCommunity Team
- Matt_Burr
- updated 5 yrs ago
- 1reply
- 1,404
- 1
- Last replyPeter Sprague6 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
- 6 yrs ago
- 1,384
- 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,…
- 6 yrs ago
- 637
- 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 .…
- 6 yrs ago
- 614
- 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…
- 6 yrs ago
- 667
- 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.…
- 6 yrs ago
- 573
- SQL Issues

Welcome to the community!

User Community

SQL

Change SQL ConnectionString to BI Office repository

Call Stored Procedure

How to hide Microsoft 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

Home

Key Resources