Very Computer

1. Formating question and member properties

Im new to MDX and OLAP.

Using the sales cube from the foodmart database I havent found a way to
format some query with aditional information from a dimension.

For instance I can make a query like this

select
    {[Measures].[Unit Sales]} on columns,
    {[Store].[Store Name].members} on rows
from Sales

which produces an output like this

Store 6            21,333.00
Store 7            25,663.00
Store 24          25,635.00
etc.

BUT WHAT IF WE NEED TO DISPLAY THE NAME OF THE MANAGER OF THE STORE BESIDES
THE STORE'S NAME?
Like This

Store 6                 Maris                       21,333.00
Store 7                 White                       25,663.00
Store 24               Byrd                         25,635.00
etc.

I wish it can be done with different fields and not using a computed
dimension.

I dont know how to do that with a MDX Query, I think that it should be
using the member property, but how.

Could it be possible using Excel 2000?

Thanks

2. Distinguishing a Drag from a Click in VFP

3. Formating SQl to show fractions - How?

4. D.C. DBA's or UNIX Admin.

5. Formating Dates

6. Update method doesn′t work

7. Need help !!! Formating date field

8. Stored Procedures vs. Embeded SQL

9. FORMATING GETDATE to display 24 Hour Clock

10. Formating, Padding & Replace (6.5)

11. Formating Dates

12. Help Formating a date in sql

13. formating Date