Metadata Model for use in Analysis and Report Studio

[rkiss]

Hi,

I just can't figure it out how Framework Manager dimensional modeling works.

I mean, I understand the concept of dimensional modeling, but I think I read too many manuals and I got confused..



here is my very very simple scenario....I need to use this model in Analysis and Report Studio

I have 2 tables that I will import to framework manager. There are NO foreigh keys set up.
I will import these tables without any relationships.

Table 1: DimStatus (status_id, status_name)
Table 2: FctServiceTicket (serviceticket_id, status_id)

After the import, I will ensure that query item properties are set up correctly...



Table 1:

status_id = identifier
status_name = attribute

Table 2:

serviceticket_id = identifier
status_id = identifier


Now, my question here are:

- Do I need to convert table 1 to regular dimension so the package will be available in Analysis Studio?
- Do I need to convert table 2 to measure dimension so the package will be available in Analysis Studio?

I would like to get a count of serviceticket_id by status_id (where memeber_caption is status_name)


How can I accomplish this?

Thank you

Roman