Pyramid
Help
Learn
Support
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,…
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
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,…
6 yrs ago
484
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.…
2 yrs ago
1,275
SQL Issues
Key Resources
60s User Survey on MS Excel
Community Tour
Register for Training Webinars
Learning Resources
Pyramid Tutorial Videos
Pyramid Help
Getting Started with Pyramid
BI Office
BI Office Help
Top contributors
View all members
Recent activity
Recent Tweets
Follow @PyramidAnalytic
Home
Pyramid
Discussion Forum - Q&A
Technical Solutions
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Key Resources
60s User Survey on MS Excel
Community Tour
Register for Training Webinars
Learning Resources
Pyramid Tutorial Videos
Pyramid Help
Getting Started with Pyramid
BI Office
BI Office Help
