Search results for query: *

I am building a new olap cube. this will have 2 time hierarchies. The cube will contained named sets such as current month. I believe that I will need to create 1 name set to show current month for one hierarchy and another named set to show current month for the other hierarchy. My ideal...

This is something completely new to me. I am lookin ag publishing an internal web site showing data stored in a SQL server database. I can get my head around the web page but dont know how to link to the database to get the data? Anyone recomend some source code / usefull sites etc. Thanks...

SQL Server 2000 Analysis services Got a DTS with a script as below. Now the bit that does not seem to work is 'dsoDimension.Process processFull' I need this script to fully process all the dimensions. I am a bit concerned about the line Set dsoDimension = CreateObject("DSO.MDStore") Many...

I am creating a claculated member in a cube. This requires the length of services (a figure in days to be converted to months. To do this I am using the arithmeitic as below. (StrToValue([Company Structure D].CurrentMember.Properties("Days In Business"))*12/365.25) Now how do I insure this...

I am having a few problems. I have a server that has several databases within AS. The data source for this uses Microsoft OLE DB for Oracle as the provider. On my machine when I open Analysis Services I cannot connect or edit this data source. If I go to create a new data source then the...

Brief: I need to get data out of Excel into $ seperated file. Not a csv. Each row of data should have the same number of columns. Problem: I like simple code. Normally I manually loop from top to bottom of an excel sheet by using hard coded values and ensuring activecell.value<>"". Is there an...

I have some asp pages and am hoping to open up a tif file and display it either on a html page or open a new HTML page to display the image. It is non negotiable that the pictures are tif's. When I put in <IMG SRC = "E:\FW_EXAMPLE\0101829\ltr00001.tif"> as the code I just get the good old...

I am trying to write asp pages using vb script to show directory and files on a server so that someone can navigate easily. I know there are simpler and better ways but ASP pages were picked for a reason. I am getting an error on 'Set Files = Folder.Files' - Any suggestions? On Error...

I have three views that are linked to some base tables. I have updated the base tables. Now there appears to be no triggers to update the views and all attempts at doing this have failed as I am reasonably new to Oracle. If I use TOAD to select text from user_views where view_name like '%CGA%'...

Hi, I have some asp pages et up on one server. These display the contents of a directory. Now when I set the directory to a drive on the server everything is ok. I have mapped a network drive to the letter G and wish to see the contents of a directory on this mapped drive. Problem is it just...

Now I whacked in the Analysis services disk and loaded up - Analysis services - needed as I am doing stuff wiyh OLAP cubes. Now I notice it did not install enterprise manager - ie what I need to use to create and manage DTS jobs. Which disk is this on - is it downloadable? Cheers. Mark.

Hello, I am hoping someone here can point me in the right direction. I have used DTS a bit - but just ammending other peolpes packages and a few basic ones myself. I have the connection to Oracle and SQL select task done ok. But want I want to do is feed the data out to a file. That bit is ok...

I have a report in CE 9 that contains a sub report. There is a parameter in the main report that is ticked Green showing that it is used. Now I cant see it in the report or subreport. All I do is set it to NULL (via scheduling) and it is never used. If I go show SQL query there is a NULL in...

I am using a networked laptop to connect through to the Crystal Management Console that is installed on a server on the network. As I am accessing it through internet explorer I choose to use Windows NT authentication. Unfortunately on clicking the log on button it thinks about it then just...

I need a bit of help. I want to write a ksh file that will do the following. look at the time a file was created if the toime is older than 30 miutes then copy it to another directory. Any suggestions? Thanks.

I currently have a spreadsheet with a load of data (say 100 rows). I need to call an ASP page on a server and pass the data over. Currently I call the ASP page as part of a loop. But I need to kill the explorer page once the page has processed the data otherwise we just stop there. I have been...

project outline: a file will be detceted, the contents read in to the application. The application will then access a server and interact with crystal enterprise to distribute the reports. I can interact with Crystal Enterprise through the use of ASP and VB script. Howeve I can not seem to...

The problem is as follows: I am to develop an application to communicate with another server (Crystal Enterprise). I started work in C# and hit problems. I then went to ASP pages with VB script. This started to work but not acceptable. I am looking to build an application that will when...

I have one report in CE 9.0. This report has about 100 instances scheduled, each one will have different parametrs and different peoples name in the to address. They are all shipped out via SMTP. The address for the particular instances are changing all the time. I do not want to have to be...

Ok, I kinda asked a few questions about this before. Having now got a little understanding of .net I am hoping for some help. I am looking at retrieving info from a CE9 server. Particularly the history page for one or more reports. I am hoping that .NET will allow me to build an application...