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...

Changed code to this. for each objDimension in dsoDatabase.Dimensions dsoDimension = objDimension dsoDimension.Process processFull Next However thgis appears to do an incremental process of dimension rather than full process. Whats wrong with the code. Cheers. Mark.

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 have formatted the string in the cube. However when the data is extracted from the cube then we are seeing the unformatted data rather than what we want. Rather than alter the format I wish to ammend the value that is stored. ie dont format 119.47 but change its value to 119. Many thanks. Mark.

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...

If it was pointless I would not have asked the question. I will have a a look at thje FAQ. Hopefully this should not happen in the real application as the file should be data out of a db that will be sent in XL format and then exported to $ seperated for re-importing. Many Thanks. Mark.

What a plonker I found a cell with data in further down. My apologies. Thanks. Mark.

Xlbo, I tried this, I have 3 rows of eight columns and the data returned via the above method gives 269 Rows and 24 Columns? Any idea why? Thanks. Mark

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...

Thanks. To think I got in the office this morning and was about to give up on this. I will have to spend some time looking at the conversion. Its going to be a long job and I have a feeling these images will need to be printed. They were originally scans of handwritten letters that needed to...

I tried Alternatiff but that does not work as a solution. At this rate it would be easier to give up and tell the users to use windows explorer to locate the tif's and then just open the file. Had a look at ImageMagic but again not a 100% match to what I want to do. I will start to have a look...

we are talking 80Gig of pictures. So even an automated process of converting would not work as I need to store in .tif and in the new format. The person with pointy hair has deep pockets and arms shorter than very short arms, so nop chance of extra storage space. Thyanks Rye, Chris I will have...

Here is the problem there are litterally hundreds of thousands (about 176 thousand of these tiffs) they are all logged in a directory structure ie issue no 1 is kept in directory 00001. Then inside the directory there is a SubDirectory for each contact with this issue ie 01,02,03,04,05 ...

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...

Thanks tsuji, I am not sure about server.createobject I amjust a mere dabbler in this. I have all the pages stored on a windows server that has IIS. I then open up the web page and it normally kind of works. I have done similar for crystal enterprise and was hoping to modify some of the code...

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...

thanks for that. I can now see the text and have done create or replace to recreate the view. I will now start to see if I can build the OLAP cube from the view which is the end target. Cheers for that. Mark.

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%'...