User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Product
BI Office
BI Office - Knowledge Base
Troubleshooting
SQL Issues
Latest Activity
Q&A
Best Practices
Learning Live Archive
Learning Live Topic Suggestions
Tips & Tricks
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Tags
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
639
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
616
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
669
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.…
updated
2 yrs ago
1,279
SQL Issues
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Learning Live Archive
Learning Live Topic Suggestions
Tips & Tricks
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help