Skip to Content

How to fill empty cells

Dec 28, 2016 at 10:55 AM


avatar image


I've a query which comes from a multiprovider. One of the cubes has the sales with the different periods 001.2016, 002.2016 and so on. And the another one has an unique period '000.0000'.

Now in the query I've the following:

Period # and COST ratio comes comes from my second cube and the rest of periods and KG ratio come from the sales cube.

And I'd like to have the following, if possible:

Can anybody help me?

Thanks in advance.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Cornelia Lezoch Jan 11, 2017 at 01:38 PM

Hi David,

the pictures are not shown here, so I can only guess what you want to achieve.

Try constant selection in your query to bring values from different cubes and with different char values together.



10 |10000 characters needed characters left characters exceeded