Pyramid
Solutions
Learn
Company
Pyramid Analytics
User Community
How to enable Javascript
Sign Up
Login
Home
BI Office
BI Office - Knowledge Base
Troubleshooting
SQL Issues
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Tags
Clear filter
Search
Follow
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,…
4 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 .…
4 yrs ago
608
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…
4 yrs ago
659
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.…
4 yrs ago
562
SQL Issues
The Pyramid Repository Cannot Be Created Within the SQL 2005
Although Pyramid does support connecting and analyzing SSAS 2005 cubes or higher, Its main repository needs to be kept with in SQL 2008 or higher. This is due to scripts,…
4 yrs ago
481
SQL Issues
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.…
10 mths ago
1,246
SQL Issues
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
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
Top contributors
View all members
Recent activity
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