Search results for query: *

We've got a couple cubes that have Invoice Line level data which includes an Item and Invoice Dollars. There's an attribute of the Item dimension, a Y/N flag, that is used as a slicer in a calculated measure. Meaning that we only want Invoice Dollars for Items that have this flag set to N...

I have a cube that has invoices in it. Dimensions around the invoices are customers and item categories. Our marketing area wants to get a count of distinct item categories purchased by each customer. Then they want to take all the distinct counts at the customer level and sum them up and...

A teammate figured it out. Somehow the cube itself was set to "Visible = False" which prevented it from being seen via Cognos and ProClarity. Thanks for your help!

I have an AS2005 cube that's on multiple servers. The cube can be browsed through SQL Server Management Studio on the various servers. However, I cannot connect to the cube from Cognos 8.2 or ProClarity 6.2. The roles have not been changed in the cube, but I checked them and they're set up...

I have a calculated member that I'm trying to limit based on a selected member of a dimension. Here's what I have now: IIF ( ([Invoice Transaction].CurrentMember IS [Invoice Transaction].[Invoice Transaction].&[1], ([Measures].[Invoice Dollars], [Invoice Transaction].[Invoice...

Sorry. I was in the wrong DB. That's why it wasn't finding it! Thanks for your help!!!

Thanks for your quick response. When I run this without the WHERE it's not pulling back all columns that I know are in the table. Why would this be? Thanks!

How do I check for the existence of a column in a table for SQL Server 2005. Thanks!