Search results for query: *

Newbie question: The "Category" Hierarchy has two levels. I want to show both the Category and Sub-Category as my rows. It's easy to check these levels in a Pivot Table, but how do I get both to show up using MDX? I'm using the syntax: {[Category].[MainCategory].members...

Is there a work-arund for the limitation that only one measure in a cube can be a Count Distinct? I've got two! Thanks for sharing!

I created a cube on my server, then connected to that cube using MS Excel from a client system. I didn't like some of the dimensions, so I deleted and re-created the first cube, and created a second cube. Now I can't connect to any of the cubes from Excel. I get the message "Excel cannot...

Somebody sent me lots of data in a self-referencing hierarchy. There's an "ID" field and a "Parent_ID" field. In another popular database, I would use a "Connect_By" clause. Is there a way to do this in SQL Server? Or has someone got some spiffy TSQL code to recurse...

I have several SQL reports I want to run from a single script file. I'd like the output from different reports to go to different files. I can't find a script command to do this. If you don't know the answer, can you tell me where to look?

I'm sending some data to a client to load. I want to give the client an easy way to load the data -- simple for them and quick for me to prepare. The easiest way I can see to do this is to write a load_data.sql file with a series of BULK INSERT statements. Some of the original data is in SQL...

How does Access come up with the field "|" from the expression: Private Sub Child2189_Enter() If IsNull([PCOs/COs]!IssueDate) Or [PCOs/COs]!IssueDate = "" Then Me.AllowEdits = True Me.AllowAdditions = True Else Me.AllowEdits =...

My JPEG's on new records are only displaying as icons on my form. Older records are displaying the previews of JPEG's that were embedded in the database fine. I have this problem if I embed or if I link the pictures. I have this problem when the file association for the .JPG and .JPEG...