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
Yes, it's possible. In the Business Layer, you can add columns and put static values in it.
Thank you for your response.when I try to add in BL it is asking reference from DL.Please advise
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.