dummy column in FM

[cielo]

Deal All:

is there a way we could create a dummy column in FM. Let's say ABC.cloumn1 is not present in DB though I would like it to create with same and get it promoted.this is  to publish my package even DB fields are not ready.whenever they are available in DB I will use in the reports.idea is to promote the package without DB dependency.

Please share your inputs

[cognostechie]

Yes, it's possible. In the Business Layer, you can add columns and put static values in it.

[cielo]

Thank you for your response.when I try to add in BL it is asking reference from DL.Please advise

[cognostechie]

I don't know what you are doing. When you create a new Query subject, you can add a column with static values without pointing it to a query subject in the DB layer. You can also create a Query subject by pointing it to a query subject in the DB layer and still add a column with static values.