Problem with Excel 2000 and OLAP

Ciao,
I have created some cubes in my Analysis Server (SQL2000
Server) and try to retrieve the cube data by Excel2000.
In my own computer, when I create the data source in Excel, I
have not the options for "Microsoft OLE DB Provider for OLAP
Services" and "Microsoft OLE DB Provider for OLAP Services
8.0".

I have installed the Analisys Services..

Can anyone help? Thanks!

FabrizioHi Fabrizio,

below is the step i use retrive cube data from excal 2000.

1) in Excel 2000 click Data --> PivotTable and PivotChart Report
2) in pivot wizard step 1, choose external datasource.
3) click get data
4) click <new datasource> at OLAP CUBE tab
5) select OLAP Provider.
6) select Microsoft OLE DB Provider for Olap Services 8.0
7) click connect --> analysis server --> enter server name
8) it should display a list of OLAP database, select your database & cube.

cheers,
suhfui|||Sorry but I haven't Microsoft OLE DB Provider for Olap Services 8.0.
Why?

Thank you|||You need to install PTSFull (Pivot Table Services) on your client as well.

It can be found in SP3 for Analysis Services in the folder

sql2kasp3\msolap\install\PTS

the 8.0 version is available after that.

HTH Lutz

Problem with DATE FORMAT

Ciao, I've a view with a smalldate field (yyyy-mm-dd hh.mm.ss) MyDate
I put in my report a formula field, I want that MyDate is formatted as dd-mm-yyyy , i've tried a lot of solutions but when i launch the report from a vb application i get the error "20515: E' necessaria una data" (a data field is required)
But... the original field is a date!!! I don't understand what's the problem , could you help me?
I'm using Crystal Report 6.0 and Visual Basic 6.0Hi,
Can you post the code used in the Formula filed?

Madhivanan|||Try using the Convert in your formula field: CDate({FieldName})

Also, the end result of a formula field must be only 1 data type. Example: 'The Date is: ' & {DateField} is trying to concatenate a string and a date, Crystal doesn't like that. In order to avoid an error in this case, you would need to convert the Date to a string. If you did that, you would have no control over the Format of the date. In this case, you can set the Report's default Date Format to what you need (For CR 8.5, it located under Designer, Default Settings, click the Fields tab, then the Date button or Date/Time button).

How are you getting the Field to Crystal Reports? Make sure that it's passing the correct variable type. You may be getting the error because the date field is getting passed in as a string.|||I'm passing a smalldata field!
In my db is "2004-11-10 00:00:00.000", I want to view "10-11-2004" but i can't do it.
I don't understand how to format it right :-\|||I'm passing a smalldata field!
In my db is "2004-11-10 00:00:00.000", I want to view "10-11-2004" but i can't do it.
I don't understand how to format it right :-\
do u know VB.net...if yes do u mind helpin me :confused: please lemme know...
thanks!|||I know VB|||I have not looked at this in detail, but just check the data type - Crystal has both Date and DateTime fields, and the field you are using looks like a DateTime, not a date.

Dave|||Hi Surrender79, Try this. Create a formula filed having the following code
replace(totext(cdate({DateField})),"/","-")
and place it in the details section. Now you can see what you expected

Madhivanan|||:(

I've put my date (smalldate type) in a formula field as below:
ToText(Day ({MYDATE}),0)
+ "-" +
ToText(Month ({MYDATE}),0)
+ "-" +
ToText(Year ({MYDATE}),"####")

If I launch the report directly from Crystal Report preview I got the right date but when I call the report preview from VB automation, I got the error "A data field is required" ____
I've CR6, some of your suggest are not good in my reports.

Thanks anyway
Ciao :)|||Hi Surrender79, did you get any error in executing replace(totext(cdate({DateField})),"/","-")
Madhivanan|||Yes, It doesn't recognize the command "replace" and "cdate", infact in my crystal report I haven't those options :(|||In menu file "Opzioni Report" (Report Option) there's "Converti campo data/ora" (Convert date/time field).
Default setting is "Stringa" (String), so I've setted "Date".

But now... i've a other question: how could I edit the report settings from vb code?