Recent content by tmunson99

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