Filtered CUBESET from related tables : Is it possible ? RRS feed

  • Question

  • Hi,

    First question here ! So thank you in advance for your answer !
    Hopefully I can get help !

    My goal is to obtain a filtered CUBESET containing all the ContractName based on the ScenarioNum.

    Here's how to understand the PowerPivot structure :

    I have a table Contracts containing all general information on my contracts.
    I have a table Scenarios containing multiple scenarios about which contracts I should consider in my scenario
    I have a table ContractsByScenario that specify wich contract is in each scenario

    So now, my goal, as I said before is to obtain a CUBESET containing all ContractName filtered with a specific ScenarioNum.

    I can't figure how I can obtain that.

    Somebody knows ?

    If you guys need more details, feel free to ask !
    Thanks !
    • Edited by murphys23 Thursday, March 19, 2020 6:13 PM
    Thursday, March 19, 2020 6:10 PM

All replies