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

That's work great except I have exactly what you described. My "Total" label is on the right and it takes on the color of the next grouping. If we could figure that out, it would be perfect! Great idea to assign the color to a variable. It's strange that it would assign it the next color...

No problem...a couple modifications just for privacy, but you get the idea. IF GridRowColumnValue ("vw_LBR_Payroll_Summary.BA") STARTSWITH "AAA" THEN crLime ELSE IF GridRowColumnValue ("vw_LBR_Payroll_Summary.BA") STARTSWITH "BBB" THEN Color(175, 238, 238) ELSE IF GridRowColumnValue...

Sure. Rows: vwSummary.Rate Pool vwSummary.Project Type Columns: vwSummary.BA vwSummary.BU Summarized Fields: Sum of vwSummary.Dollars Percentage of Sum of vwSummary.Dollars

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

Thanks skrandel. I finally landed that one yesterday. I thought I had to change all the data sources to business views. It works superb!

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

I should clarify that I'm wanting to use the resultset of the stored procedure to source a dynamic parameter. So a user who has access to Division 1 will only see Division 1 in his parameter choice and a user who has access to Division 1 and 2 will have Division 1 and 2 as a dynamic parameter...

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

Thank you for your suggestion. I haven't had much luck deploying it though. (I'm new to Analysis Services.) Percent Hours and Percent Dollars are already a measure, but I want to hide them at all levels except Employee > Project levels. I tried creating a calculated cell for Percent Hours...

dsa.msc /server=server1.domain1 is EXACTLY what I was looking for. I created a shortcut and it works perfectly. Thank you very much.

Is this something I can do from my MMC? I'm an application administrator not a network administrator so I'm probably not phrasing my question correctly. I definitely don't want to do something that would affect the whole network. I just want my MMC to default to a particular domain controller...

Yes, we have 20+ sites across the country. My original question was not whether our network was set up correctly but whether I, as one of many IT support people, could easily control which domain controller my Active Directory console automatically connects to.

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

Thanks! I appreciate it. That does make sense. I will try it.

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