|
Conjunction Junction
by Aaron Zechman, Sr. Consultant, BOCP – CR, BOCP – WebI. MCSE
Just like the conjunctions “and”, “but” and “or” can get you far in grammar, so can some basic excel functions inside a Crystal Xcelsius model or your excel spreadsheet. So we are going to go over some functions so that you have them available when you need them such as: VLOOKUP, HLOOKUP, AND, OR and IF.
Read the full article...
SQL Server System Databases
by Michael C Mullin, Consultant, MCAD, CRCP, MCTS
SQL Server is one of those self referencing programs that use its own functionality to provide that functionality. It does this by the use of system databases. These databases store data about the user databases and about the configuration and functions of the server.
Read the full article...
|
Sweat the Small Stuff
by John Haskell, aka Dr. Revenue
If you are doing the same thing today expecting different results, you will be disappointed. The current market is shrinking. You must take an increasing share of a decreasing market to maintain or increase revenue and profits. How can you do this? Simple … the “little things” have to be done!
Read the full article...
|
Business Objects Business Views |
Enforcing Report Prompts Using View Time Security
by Joe Roberts, Principal Consultant, BECP, SLE, MCP
Have you ever had a report where you wanted to prompt certain users for a value but not necessarily everyone? Or you wanted to ensure that all report designers include a date parameter in a transactional report so you could make sure that the results were limited? I get this request on a pretty regular basis so I’m guessing the answer is “Yes”!
Read the full article...
|
