Search results for query: *

Hello All, I have a query that has 11 steps in it where it creates several volatile tables in Teradata SQL Assistant. For some reason it stops after the fourth step and gives no error message, etc. I can then highlight and run the additional steps without problem. I need it to run straight...

Hi all, Currently using BO 6.5. Having a problem with a BO proc that a accesses a stored proc on our Teradata platform -- error message follows: Exception: DBD, [NCR][ODBC Teradata Driver][Teradata Database]rcr_create_facts:Only an ET or null statement is legal after a DDL Statement. State...

Thank you! That works! That was just too easy. I've did that in other query tools, just never occurred to me that SAS would allow it, but then I'm new to SAS ... thanks again, Alan

Hi Klaz, exection = execution. I am doing query development / testing. Usually try to do that in steps or pieces. Basically want to skip parts of the query that have already been developed and working correctly OR stop the job execution at certain points. Is there no way, except thru data...

Hi All, New to SAS. Is there a way to jump to different parts of a SAS query or stop/end a SAS query. I don't want to do this in a data step. For instance, if I want to skip the first several statements and jump to the middle of a query or simply stop the query itself. I would think that...

Thanks for taking the time for all the input, Chris. Great info. We use WebFOCUS here now, but as I mentioned, we are being pushed towards SAS (company standard). WebFOCUS is also huge, and the more I've learned about it, the more I seen that I needed to learn. I don't so much mind the...

Thank you, Klaz. Really appreciate the feedback. One last question. Taking your average programmer/reporting analyst or data analyst, in your opinion, how long would it take to become really proficient/good with SAS -- if they use it on a daily basis? Alan

Thank you!! Chris. Very informative. Beginning to think no one was going to respond. Yes, there are a couple of follow-ups. 1. Is there a way to schedule SAS procedures to kick off at certain times of the day on an automatic basis? 2. In a nutshell, what are SAS's three strongest...

Hi All, My company is pushing us towards the SAS product. I am trying to determine some of its' capabilities. So, I figure the best way to do that is ask experienced users. Can any of you experts tell me if SAS can do the following? 1. Input from or output to the following platforms...

It's an independent table.

Hi MDXer, When trying to process this cube, it eventually fails and says that the "connection was lost." However, in a effort to understand where the problem was I recreated the cube adding each dimensional table (5 in total), one at at time, and then attempted to process after each step ...

Hi All, I'm trying to process a cube. The fact table has around 13.6 million records, and there are 5 dimensional tables. Nothing out of the ordinary. All the dimensional tables process, but once it gets to creating the partition it hangs up and eventually fails. I've had no problems w/...

Thanks once again, MDXer. Looks like I'm just going to have to get in there and see what I can with AS. Company wide, there are all kinds of reporting tools used. There are some folks in the company that use AS already, I've heard, but it's not widespread or in my area. I'm just looking into...

Since we are on this subject ... it has brought to mind more questions ...... As I have posted on here before .... I am researching Analysis Services (AS) for use where I am employed. At this juncture, I do not have a clear picture in my mind of why I would want to use AS. As posted above ...

MDXer, You were absolutely correct!! That worked. Thank you! Alan

Thanks for the reply. I did as you suggested above and then went into AS to create a data source. The test connection worked. However, when I go to build a cube, I get this: Error: [NCR][ODBC Teradata Driver]Not enough info to log on Doesn't make sense to me that the test connnection...

Question: I am trying to connect Analysis Services (AS) to a Teradata database. When I go into AS and try to create a new data source there is no OLE DB Provider for Teradata. Has anyone ran into this? Any solution? Thanks for any help !! Alan

Same problem I was having. Installing AS SP3 fixed it. alan