Skip to Content
author's profile photo Former Member
0
Former Member

Time characteristic restriction in BW BPS

Posted on Aug 20, 2007 at 10:05 AM 24 Views

Hi to all,

I got one question for BW-BPS. This was happened after upgrade of Netweaver

service pack. Before that it was fine. My question is as follow:

Under DW workbench when I create an InfoProvider which included time dimension

that consist of fiscal year, fiscal year/period, posting period, calendar

year, calender year/ month. I try to select fiscal year, fiscal year/period

under a planning level, then I select unassigned(#) time characteristic for

fiscal year/period and save it. System allow for this restriction under time

characteristic fiscal year/period. However, if I deselect fiscal year, fiscal

year/period under a planning level and select calendar year, calender year/

month under the same planning level, then I select unassigned(#) time

characteristic for calender year/ month and save it. System was not allow for

this restriction for time characteristic and generate the following message:

Message: UPC003- Value# is not permitted for characteristic calendar

year/month.

There was no characteristic relationship set for time dimension

characteristics. I still not understand why system is not allow for

unassigned(#) time characteristic selection for calender year/ month

Therefore, I would like to need a support for this. Is it a system error?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 20, 2007 at 11:54 AM
    1

    Hi Chek,

    I dont think it is a system error. In BI-IP, there is an automatic characteristic relationship that is provided for the time characteristics like 0calday, 0calweek, 0calmonth, 0calquarter, 0calyear which we earlier needed to model in the planning application in BPS. You can check this very easily by creating an aggr. level with only 0calmonth (but not 0calquarter, 0calyear which should be in the cube), and populating the cube with record(s). You will see that 0calquarter, 0calyear will get automatically populated with corresponding values (using derivation).

    That should be the reason why system is not taking # as restriction for 0calmonth, because it cannot derive the corresponding value of 0calyear.

    Why do you want 0calmonth to be blank?

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 03:13 PM
    0

    Hi Chek Keong Ng,

    Can you put value 000000 instead of # in 0Cal Year/month and then check....

    I believe, in the master data table # does not exit. That is why you are getting error. (check in the master data table /BI0/PCALMONTH).

    Similarly put Cal year 0000 and calmonth 00.

    This is all due to master data tables..... where # is not there.....

    Please check and let me know..

    Thanks

    Abhijit Misra

    Add a comment
    10|10000 characters needed characters exceeded

    • Thomas Markus
      Dec 03, 2007 at 04:10 PM

      Hi,

      I don't want to speak for Chek Keong Ng. But as we've got the same problem I'd like to answer it for us if this is ok. I've tried putting 000000. The value 'not assigned' is definitely part of the master data table.

      The amazing thing is that the error message only appears when time characteristics are concerned. All other characteristics are ok.

      Thanks,

      Thomas

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.