Question:
Hi all,
I am looking for some help to solve a problem. I am creating a query to display characteristics and keyfigures. Not too much a problem, but I want to add some defaulted values into the workbook results. for example if I want to add the source system Id into the query results as a column.
Anybody got any ideas
Thanks,
David
Answer:
Hi David,
Do you have the infoobject source system in your cube? If yes, in the query, you can retrict to the source system you want. Alternately, you can do the same (retrict) in the transfer rules, select constant, input the source system you want, when do the transfering.
Answer:
You can create a furmula column in the query, hard-coding the value (source system id) as the formula definition i.e. if the system id is 100, then the formula is simply '=100'.
If the value neesd to be specified by the user at time of query/workbook refresh, then you can use a 'formula variable' in the formula definition. On-line Help explians this well.
Answer:
Thanks to all who replied,
I used the second solution recommending Formulas and Formula variables as we did not have an infoobject for source system in the cube.
Regards and thanks again,
David