Question Re: Input data at Parent Level in Additional Q&A

Input data at Parent Level

Former Member — Tue, 15 Jan 2013 14:54:19 GMT

I want to enter data at Parent level, my requirement is

Project1
CE1
    CN1
    CN2
CE2
     CN3
     CN4
Project2
CE4
     CN5
     CN6
CE5
     CN7
     CN8

there are 6 columns, in first two columns user want to enter at CE1 level which is parent of CN1 and CN2, CN1 and CN2 should grey out

other two columns user need to enter at project level Project1 and Project2 which is parent of CE1 and CE2, here CE1 and CE2 are grey out.

remaining two columns user enter at Base level members which are CN1 and CN2.

I can enter at base members but how can I input at parent level CE1 and Project1, Created Dummy ID's for parent members.

In same Input schedule need to appear the values again what ever entered at project1 level.

please let me know.

Regards

Klien

Re: Input data at Parent Level

Former Member — Tue, 15 Jan 2013 15:13:29 GMT

Hi Klien,

which software are you using? which version?

Kind regards

Roberto

Re: Input data at Parent Level

Former Member — Thu, 17 Jan 2013 00:21:19 GMT

Hi Roberto

I'm using BPC7.5 NW version

Regards

Klien

Re: Input data at Parent Level

Former Member — Thu, 17 Jan 2013 09:18:03 GMT

Hi Klien,

If you have 3 types of columns in the same input form, it will be a problem in correlating the data. Let me give you an example.

In the first column, you enter data for CE1_INP. CN1 and CN2 are greyed out.

But in the subsequent column, the user is also entering some data in CN1 and CN2. This data will be rolled up to CE1. Then what is the purpose of entering data for CE1_INP in the same input form.

Re: Input data at Parent Level

Former Member — Thu, 17 Jan 2013 09:28:19 GMT

Hi Klien,

BPC is based on OLAP DB, so the parents will automatically calculated from BPC, you can create a CE1_INPUT in the hierarchy and use it but you must be sure that it will be used alternatively instead of CN1 and CN2 or the parents will have a wrong value.

Kind regards

Roberto

Re: Input data at Parent Level

Former Member — Tue, 22 Jan 2013 15:36:08 GMT

Thank you, sorry I'm out of station these days so couldn't reply to your answer, problem resolved, at CE level creating dummy inputs, and user won't enter at CN level.

Regards

Klien

Re: Input data at Parent Level

Former Member — Tue, 22 Jan 2013 15:41:30 GMT

I have one more scenario in input schedule which need to grey out at intersection of row and column i.e in Row I took Project dimension and in column percentage

percentage

AE1 grey out

AE2 grey out

AE_GST User need to enter data

PE1 grey out

PE2 grey out

PE_GST User need to enter data

how can I grey out intersection of the cell which is "GST" project, dynamically members will be expanded, I try in format cell, by hardcoding as

project.id = AE_GST row format LOCK data

but worked only for "AE_GST" remaining GST not worked, how can I do this, should I need to write any macro, if so can you please let me know how to write it as I'm new to Macro

Regards

Klien