Search results for query: *

I'm trying to get a count of households where there is not a Head of household defined. There are different account types for different members of a household - but there should only be one head of household. Please help! My query is set up like: SELECT HH, COUNT(HH) NumOccur FROM HHOLDS...

Hello, I have been out of the Business Objects arena for several years. The last version I worked on was either 5 or early 6. I am now going back into BUSOBJ with the current version. From what I understand, the architecture has pretty much completely changed from previous versions. Having...

Hello, Am looking for any comments on using Business Objects' ETL tool, Data Integrator as a stand alone. For a small, startup company, not alot of data sources, not alot of data..yet. Will implement using MySQL data warehouse. They are looking to pair it up with MicroStrategy on the front...

Hello, Has anyone used DI as a stand alone ETL tool? Can it be used stand alone and then another BI reporting tool be used on the front end? thanks, p.p.

Does anyone know/remember the shortcut key combination to get MSTR Desktop to show you the SQL that was executed to generate a prompt? As I recall, you would execute a report, then you are presented with the prompt. At that moment, you could do something like ctrl-alt-m-o-u-s-e and get a window...

Is there an advantage of running BO (Crystal Decisions) on Linux vs Windows O/S? Are there disadvantages? Comments welcome. thanks

For a small startup company, does anyone have a baseline for hardware specs for a BO implementation? I am looking for a windows platform, memory, CPU, processors, etc. I know what the 'recommended' minimums are; but am looking for some real world configurations that work well. Environment may...

any idea why this: update individual set referenceid = 11 where individualid in (select refid from ref_temp2) would generate the following error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <= , >, >= or when the subquery is used as an...

Hello, We have been tasked with decrypting certain fields within the data warehouse, ie, credit card number. If the value is stored as an encrypted field, is it possible to run a stored proc to decrypt the value so that it can be displayed on a report or used to join to another table? Would...

Hi, I have a navigation set using the 'Jump to URL'. Is there a way to have the name of the field change color (red) and underline when mouse over? Currently the mouse over just displays what I have in the tooltip, but I would like it to also change color and be underlined to appear more...

I am very new to C#. I need to create a windows app to practice multi-threading. My form is simple with a start button and a stop button, and 2 text boxes to display output. Requirements are: the Start button 1)creates a SharedMsg boject and a SharedClick object 2)creates a Server object and a...

New in version 8.01 (GA in a couple of weeks), MSTR now integrates with several portlets. One of which is Microsoft's Sharepoint server. I have been trying research this for awhile - and am not exactly clear on whether or not MSTR Web must be loaded on the same server as Sharepoint in order to...

Reading more about SQL Server, I discovered that there are only 2 datatypes to handle dates, smalldatetime and datetime - both of which store timestamps. I am confused however, how when displaying dates in RS, you only display the date portion of the field. Is this possible to do in RS...

Hello, Still quite new to RS, I am learning the tool with books and by just playing with it. Is there a limitation as to how many tables you can add in a dataset? Does it get complex as to how the tables can be joined together? Are you able to specify the join relationships? Just curious as...

Hi, this is my first time working with Reporting Services. I have a report built and am trying to deploy it to the target URL, but the build message tell ms me that the permissions for user 'me' are insufficient for performing the operation. Is this an IIS priviledge I'm missing or is it SQL...

I have a new project which involves the clustering of IServers. I have a couple of questions regarding this: 1)Has anyone used a monitoring tool other than PERFMON for capturing usage and performance? I would like to get some stats on before/after performance. I find PERFMON somewhat...

Does anyone know of an XSL that will put the attributes and metrics on one row, and also remove the 'metrics' column? Thanks

Hi, Still learning C#...I am trying to pass 2 arrays to a report menu. I keep getting 'Identifier Expected' error. MSDN says its to replace the keyword with a user specified identifier. I'm not sure what its looking for. It's giving me the error at the reportMenu method. Here's part of my...

Hi, I am learning C# and would like some advice from the 'experts'. I am having some trouble with the layout, ie naming of classes, etc. I was told to give classes a logical name, ie. Customer - but then how do you typically name the class which contains the main() method? I was naming this...

I am trying to get attribute roles to work and have not been successful. Maybe its the way I am trying to use them. Here's what I have: EMPLOYEE table has EMPID, SUPERVISORID and EMPL_NAME. I am trying to get MSTR to use the Attribute role feature to avoid having to create an alias EMPLOYEE...