Use FAP dimensions in other cubes?

[fstuyck]

Hi,
I had an issue with publishing data from within Cognos Controller to the FAP.
The issue is probably due to the fact that I use the FAP dimensions in a new reporting cube?

What is the best way to work with dimensions create by the FAB?
Do I need to create a process that copies the FAB dimensions and use these duplicates to create new cubes?
Thanks.

[scrumthing]

I would never use the FAP dimensions in another cube. Always copy it. I am not sure (my last project involving cognos controller was a while ago) if those dimensions get destroyed in any way when new data gets published. So MAYBE that is an issue. I only remember never to use them.

[lotsaram]

You already answered the questions. So I think you already knew the answer!

I had an issue with publishing data from within Cognos Controller to the FAP.
The issue is probably due to the fact that I use the FAP dimensions in a new reporting cube?

Yes probably. Everytime FAP is published the FAP cube and all the FAP dimensions are completely destroyed. All data will be gone, all subsets will be gone. Basically it's an appallingly bad design.

What is the best way to work with dimensions create by the FAB?
Do I need to create a process that copies the FAB dimensions and use these duplicates to create new cubes?

Yes definately. Whenever we do anything with FAP we always have the FAP cube as the data source and then clone the dimensions to reporting dimensions and likewise load the data to cubes where it won't get lost on the next publish.

[Emixam]

Do I need to create a process that copies the FAB dimensions and use these duplicates to create new cubes?

If you want to save time, you should use the bedrock TI. That's what we are doing and it works perfectly.

[fstuyck]

Hi,
Thank you for the response.
The bedrock TI tip was especial useful, great TI code.

[Wim Gielis]

Hi Felix,

For some further reading, this topic has been discussed here as well: viewtopic.php?f=3&t=15331