01-11-2023 09:58 AM - last edited on 05-24-2023 12:06 PM by JackLacava
Hi - Is it possible to drill back to the Analytic Blend tables from the cube data? I have an CV MD adapter which pulls the data from CV, and I created a Map & Bar chart and I want to create a Drill Back to the Analytic Blend tables because it has SKU & Customer level data which is not present in Cube. I am able to create the separate but not able to integrate. Do I need to create any Connector Rule? Any thoughts on this topic would be appreciated?
Thanks
01-11-2023 11:40 AM
In order to clarify the issue, let me know if anything I state here is incorrect:
- You have a CubeView MD adapter pulling data from a Cube View (hence cube data); you have a chart populated by that adapter
- You have some sort of BiBlend table. I guess it was somehow produced by the same Stage Data that ended up being loaded in the cube (?)
- You want to somehow link the two
If that's what you want, that's not a DrillBack, so let's drop that term.
There are a few different ways to go about this problem. If you want to avoid code, you could
I suspect your issue is with 1, and solving that will depend on which components you are using. You say you have a Map, so I guess you used the BiViewer component...?
01-11-2023 12:10 PM
Thanks, Jack, for the Quick Response. I will try with the Grid approach with SQL and Yes I am using the BI Viewer component.
01-12-2023 12:35 PM
To add to what Jack said, drill back can only happen if you've loaded the data to the cube using your source. Then yes, you can define the drill back in your connector rule, or it is always custom development using dashboards or relational blend members.
01-12-2023 12:43 PM
Thanks ckattookaran.