473,231 Members | 1,821 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Cannot connect to the cube via pivot table control


I am using a pivot table control (OWC) via web access to an analysis server.

My connection string is:

ci.ConnectionString = "Provider=MSOLAP.2;User ID=peterdev01\\" + the_username +
";Password=" + the_password +
";Data Source=http://peterdev01/webtest;Initial Catalog=Peter ALL v2;Integrated Security=SSPI;Persist Security Info=True;Client Cache Size=25;Auto Synch Period=10000";

ci.DataMember = "PIER cubes"

I have set the above database security of analysis server to "All Users".

Then, on my pivot table control, it shows:
"The cube name 'Peter cubes' is invalid."

Why ?? How can I solve the problem?
Regards,
Peter
Jul 20 '05 #1
0 2693

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: shabnam | last post by:
I have various reports in Pivot table form using OLAP Cube. I want thes reports to be portable so i want them to call through asp so that it i available within the intranet. How do i do it? ...
0
by: Wojtek Jurek | last post by:
I have installed DB2 Cube Views. What should I do to be able to view cube created in Cube Views in MS Office 2003? In OLAP sources for Pivot Table I can see only cubes made in Microsoft tools....
2
by: eskil | last post by:
Hi, I am running a pivot table based on a query. I need to be able to display decimal precision for on a calculated field (in the query). The query returns the values correctly (i.e. with the...
0
by: Tim_k | last post by:
Does anyone have an example of how to export a datagrid to an Excel pivot table? The code below exports the grid contents to Excel using the Response object. I'd like to expand it to show the...
3
by: cmay | last post by:
I am trying to make the datalist work for me in presenting data in a "pivot table" manner, but it isn't exactly pretty. I have seen some complex code examples of people trying to re arrange a...
4
radcaesar
by: radcaesar | last post by:
Hi, I Have an PivotTable control (OWC) which displays cube from OLAP (Sql Server). Now i want to edit the Data in pivot and update the same to the OLAP Db. How can i update the data from...
1
by: thomas.wordsworth | last post by:
This is a bit of a two-part question. 1. Is there a way to control what filters are placed on a pivot chart via vba. I can easily change the underlying query and refresh pivot chart but it's...
2
by: migrant_lad | last post by:
form to view in pivot table view is based on query. form default view is pivot table and will function when the form is opened directly. The problem is that when the form is opened from a control...
7
by: J-Burns | last post by:
Hello. Need some help here. I have a 4*4 cube. So the equation of the cube becoming: x + 4*y + 16*z Now i want to rotate this cube 90 degrees anticlockwise( a right rotation). How can i do...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.