Search results for query: *

I have hopefully a fairly easy question. Can anyone tell me what the different is between (1) Processing individual dimensions and cubes and (2) Processing the entire database? In other words, assuming I want all the dimensions and cubes processed, is there a difference between either method...

I'm in the process of converting from DTS to SSIS. Overall the migrated packages have done quite well. One issue I'm having problems understanding is how to allow entry of variables at run time. We have power users that previously ran dtsrunui.exe (now dtexecui.exe). They don't have BIDS or...

I have a cross tab that I have successfully conditionally formatted the background color using GridRowColumnValue (see below). However, I can only use it to format fields and not text objects. In other words, my column total 'Total' heading is white while everything else is colored based on...

I am new to MDX statements and am at a loss as to how to formulate a percent of totals as follows. I'm basically wanting a percentage based on a column/row intersection: Measures Hours Cost LBR Employee Org Company Division Labor Category Employee Rate Pool Rate Pool I would...

Does anyone know if there is a command where you can first check to see if a primary key exists or not before you add or drop it......similar to DROP TABLE IF EXISTS .....? I currently use: ALTER TABLE employees DROP CONSTRAINT [PK_Employees] to drop the PK and ALTER TABLE employees ADD...

Does anyone know a way to populate dynamic parameter lists based on a user id?

Does anyone know if it is possible to pass a formula or Crystal special field to a stored procedure? I'm using BOXI and have a table called Security with UserId along with another information I can use for filtering. I have a stored procedure: begin create table #GetDivision (@UserId...

We have a network with 15-20 domain controllers. Is there a setting somewhere in Active Directory Users and Computers where I can default the domain controller I connect to when I open AD? It's completely random which domain controller I'm connected to when I open AD. I realize changes...

I have an employee table with changes in positions, Org, labor categories, pay, etc. (This is a simplistic view of what I'm doing, but I get the idea across.) [Employee] EmplId EffectDate OrgId Position PayRate 1234 1/1/2006 1.1.1 Laborer 10.00 1234 4/1/2006 1.2.4...

I have a dimension that looks something like: Company Division Labor Pool Employee Project My fact table contains hours and dollars representing an employee's time on a project. This works fine in the OLAP report. However, I also calculate and store percent hours and...

Is there a SQL command that will count the number of times a particular character occurs in a string? For example, I have an Org string - 123.ABC.abc.def.ghi.jkl.mno or 123.ABC.abc.def. I have a stored procedure that parses each tuple. Without getting into the complexity of the stored...

Is it possible to import parameters at runtime in Crystal XI? I know you can import a static list of parameters, but I'd like to be able to decide at runtime what to import and it may be lengthy enough that I don't want to have to pick through thousands of field values to pick my parameters...

I need help developing some logic for a Crystal report. My datasource is working great, but I need help in creating logic from that datasource. A sample of the data: Id PostDate Score 1 2006-07-09 13:00:00 2 1 2006-07-01 09:30:00 3 2 2006-07-03...

Does someone have any suggestions on how to accomplish the following. I know a stored procedure is one option, but I'm hoping to do it in a view so I need a sql query. I have thousands of records with one or more records per project id. I want to only retrieve two records per id based on the...

We have Business Object XI Enterprise and I recently added a new AD group in the CMC as well as added existing multiple users to additional Active Directory groups in Active Directory. My problem is that if I look at the Groups in the CMC, all the users are listed. It appears to query AD then...

I'm fairly new using Business Objects having come from SQL Reporting Services. The system I'm using was already installed prior to me using it. Where is the database for Business Objects XI Enterprise stored? I'd like to create a query that will list all the reports on the server as well as...

I am a newbie to Crystal Reports. I am using Crystal Enterprise XI. I have a report where the main report has one data source and then a subreport has a different data sources and I have linked to a parameter in the main report. The report runs fine in designer mode but when I deploy it, the...

I have a table of several thousand customer names. The full customer name is in one field and I want to separate it into first name and last name. There has to be a sql command that will separate or trim a string before or after a space. I've looked at ltrim and substring, but they don't seem...

My Master databases is failing the integrity check from the database maintenance plan. I also ran dbcc checkdb on the Master database and also received the following errors. CHECKDB found 0 allocation errors and 5 consistency errors in table 'sysmessages' (object ID 36). CHECKDB found 0...

I have created a calendar control so I can reuse it on various web forms. I can select a date from the calendar at run time and it appears on my web form. However, what I cannot figure out is how to capture that date in my current form. The text box in my control is txtCalendarDate, however...