Search results for query: *

Has anyone ever passed a string containing input data instead of an actual file for something like a proc import? We are using SAS IntrNet to allow Java code to go from application server to SAS server to run some code then send results back to the app server. My consultant does not want to...

I'm having a time of this. I haven't done SAS for years, and I'm trying to import a raw datafile which is exported from my database and is comma delimited. It contains num and char data, and it is important that certain columns import as the right data type or my program will blowup. I have...

Here is a recurring issue we have had for as long as I can remember.... We are currently on 7.5.4 and started on 7.5.1. When we do a lot of work like project duplication, renaming projects, deleting a lot of objects, etc. all the projects under our production project source start showing...

Just curious if anyone has a document format that they use or a list of questions specific to MicroStrategy that they use when meeting with end users to create new reports? Thanks!!

Help ! I'm not a .NET programmer but I am able to use a hyperlink to drill from one RS doc to a second RS doc. Is there any way to pass a prompt answer from the first report (first report answer same as second) to the second?? Not sure what the &xxxx parm would be. Thanks!

I'm told there isn't a limit to the number of prompt-in-prompt you can do; however, I haven't found anyone who has done more than a 2 level (inner prompt) and unanswered prompt. Has anyone ??? We're trying to capture retail product hierarchy levels where level 1 (Department) is unique but...

Is it possible to change a dataset in a Report Services document? I have only one dataset in my document; however, I have 6 grid reports I need documents created for. The grid documents are exactly the same with the exception of a different region for each one. I don't want to lose all the...

I have taken both basic & advanced NCS training classes, and I don't remember them covering how to create your own Excel sheet (with page setup to fix all on a single page). I desperately need to get this info, and I can't find a tech note or specific info in the prod manuals either. Do I need...

I'm currently on 7.5.1, and since the upgrade EM has not worked like it used to on 7.2.3. We completely purged our old statistics and recreated the stat tables on suggestion from our MSTR consultant. I'm trying to reload some old stuff, and the manual load runs successfully, but there is no...

Is it possible to take two separate (no duplication of anything) metadata repositories created on 7.2.3 both in Oracle 9i both on Win 2003 server and "combine" them? We have a contracted service project that created their MSTR project on a standalone server for testing. Now they need to get...

I think this is possible, but I need to verify: Can you run datamarts to take data from an Access source table and output it into Oracle? I have a bunch of old data stored in several Access databases, and rather than do individual conversion processes writing code I would like to use MSTR if...

Has anyone had the problem where you can drill on a report in desktop but in web you cannot? We are on 7.2.3, and in the web version I go to Data - Drill and get the popup box DRILL FROM XXXX TO XXXX; however, the option box is empty or has -none-. Is this something in the administrative setup...

We are new to Narrowcast, and I'm having problems getting my services to run automatically on days (Monday - Friday) when our database backup is done. I have batch scripts to bring the NCS services down before the database goes down then batch scripts to bring the NCS services back up after the...

dumb question but I can't find this in the knowledgebase. I think it is possible to insert a document hyperlink to an object like a Word document, but I'm not sure how. When I am in my document, normal view, and click INSERT -- the hyperlink is grayed out.??? Is this maybe a setting that...

Does I-Server look at an AS400 library as comparable to a database or a schema? I need to know if it is possible to use files from 2 different libraries in one MSTR project. Thanks!

This case statement works (29 total passes of SQL)when I run the SQL generated by MSTR; however, on the MSTR report the value shows as zero(0). The actual values showing when I query the temp tables in Oracle are long like 0.370419202, 0.260209601 and I'm thinking maybe there are too many...

I'm trying to do a decode in Oracle where if a certain value is null we apply text to it in the report results. The decode statement works in SQL+; however, when I run MSTR it shows as missing a right parenthesis. MSTR won't let me add another parenthesis ??? Help -- what did I screw up...

Is it possible to do cascading totals or "totals within totals" (something like the nested/prompt within prompting) in MSTR? I have a custom total for sales by vendor on a report. I want to add another total for type of sale within the vendor category. I can't get this to work for...

I have an attribute which is Oracle datetime format. We need to truncate the time off the date (TRUNC(opendate) ); however, in the documentation I'm seeing for MSTR the TRUNC only works on a number data type. Suggestions? Thanks!

If I want to run some type of report that will allow many data elements from my warehouse to be available for user reporting in a cache (so that when users request the elements on their reports they don't have to wait so long), would I want to do some type of report caching or intelligent cube...