RBS Mask and Lookup Table

J

JodyJ

In the Enterprise Global Template, I defined the RBSj outline code with a
mask of 1.1.11. In other words, level 1 = numbers, length=1, " ." as the
separator. Level 2 = same and Level 3 is the same only length = 2.

When I go to edit lookup table, I enter Level 1 = 1, Level 2 = 1.1 and Level
3 = 1.11.

I get an error message indicating that either my separator or one of my
fields isn't valid.

What am I doing wrong? This seems like it should be straightforward.
 
J

Jonathan Sofer - MCP

Jody,

First off you have specified that the only thing that can go in the outline
code are numbers but you are putting periods in there like when you put in
1.1

Secondly, you need to count each character so 1.1 is actually length of 3

As it looks now, Level 1 Length should equal 1, Level 2 Length = 3, Level 3
Length = 4

I would caution to use any special characters in your outline code names and
in the values. This includes periods and other characters like
/";:<>|[],.'?~`!$%^&*()-+={}\

They can cause OLAP issues and database issues down the road
 
J

JodyJ

Thanks...that helps....

I was trying to incorporate the separator, not realizing the Project would
take care of that aspect.

Jonathan Sofer - MCP said:
Jody,

First off you have specified that the only thing that can go in the outline
code are numbers but you are putting periods in there like when you put in
1.1

Secondly, you need to count each character so 1.1 is actually length of 3

As it looks now, Level 1 Length should equal 1, Level 2 Length = 3, Level 3
Length = 4

I would caution to use any special characters in your outline code names and
in the values. This includes periods and other characters like
/";:<>|[],.'?~`!$%^&*()-+={}\

They can cause OLAP issues and database issues down the road

--
Jonathan Sofer - MCP
PM Consultant
PCubed - Program Planning Professionals
--
JodyJ said:
In the Enterprise Global Template, I defined the RBSj outline code with a
mask of 1.1.11. In other words, level 1 = numbers, length=1, " ." as the
separator. Level 2 = same and Level 3 is the same only length = 2.

When I go to edit lookup table, I enter Level 1 = 1, Level 2 = 1.1 and
Level
3 = 1.11.

I get an error message indicating that either my separator or one of my
fields isn't valid.

What am I doing wrong? This seems like it should be straightforward.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top