I am still novice with Olap.

I am trying to build a cube with Employee information.

I only have one row that is numeric on the Employee table, and other rows
are all text-based (such as Employee#, First / Last name etc.).

I have other tables that could be used for the dimention.

Is there anyway I could display non-numeric information with Olap?

I would appreciate for any comment.

Could you describe what kind of non-numeric info you wish to display,
and whether you're using AS 2000 or AS 2005?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

dimensions contain generally text data like employee names
cubes contains measures like count, sum, min, max... so its allways based on
numeric values not text (except the count)

in a cube, you can create local dimension (+ shared dimension), local
dimensions can be created directly from the fact table which also contain
the values.
so, if you have 1 table with employee name and employee salary, you can
create a cube on this table, put the employee name in a local dimension and
the salary become your measure.

"Justin Doh" <JustinDoh (AT) discussions (DOT) microsoft.com> wrote

Hi Deepak,

Thank you for the reply.
Sorry that my initial explanation was not written in details.

I have a Fact table ("Employee") with most of varchar data except one
numeric column which is not useful.

I am trying to display varchar data such as First Name, Last Name, or
EmployeeNumber (varchar also) as measures, but it displays as '1'.

I do use some non-numeric data for the dimension tables, though.
And it is no problem.

We use AS2000 at my work.

I would appreciate if you give me any feedback.

Thanks.
Justin

"Deepak Puri" wrote:

Hi Jéjé,

Thank you for your feedback.

As I replied to Deepak, I am trying to display results (measure) as Employee
Name and EmployeeID which are all varchar data.

I have "ManagerHierarchy" table as a dimension table which I am trying to
tie to the "Employee" table as a Fact table.

So basically, I am trying to display Employee information (Fact table) by
ManagerEmpNum (Dimension table).

Thank you for your help and I would appreciate any feedback.

Justin

"Jéjé" wrote:

well... if there is no data to summarize, why do you create a cube?
its a complex option to render list of employees.

what do you want to display if there is more then 1 employee under 1
manager?

why you don't create a dimension based on the employee name and simply cross
join the manager dimension and the employee name dimension?
select nonemptycrossjoin(manager.members, employees.members) on rows
from mycube



"Justin Doh" <JustinDoh (AT) discussions (DOT) microsoft.com> wrote

These fields are not measures, they are dimenison members and member properties

"Justin Doh" wrote: