01-15-2024 04:55 AM
Hi All, I am trying to add two UD2 dimension members in the Cube view member filter and obviously , its not allowing me to enter them. I went through the approach of creating a dimension in UD8 and then copying all the data from the UD2 dimension to UD8 dimension in order to show the two columns. However, it is not working for me.
I used the following code in dynamic calc formula for UD8: B2C_PGC_Provider so that I can reference it to UD2 ( all member dimensions and included data):
Dim U2Filter As List(Of Member)=api.Members.GetBaseMembers(api.Pov.UD2Dim.DimPk, api.Members.GetMemberId(dimtype.UD2.Id, "Programs_Provider"))
For Each memberObj In U2Filter
BRApi.ErrorLog.LogMessage(si, memberObj.Name)
Next.
Please let me know what is wrong and how this can be resolved.
Solved! Go to Solution.
01-17-2024 05:48 AM - edited 01-17-2024 06:16 AM
I have a feeling Package and Provider should have been in two different UDs, but anyway...
I'm still not entirely sure what your output should look like, maybe it would help if you created a mock in Excel with the desired final layout and showed it to us.
Things I would keep in mind:
01-15-2024 07:40 AM
Hi,
I think it's a better approach if you create a parallel hierarchy in a UD2 dimension taking the members from the other UD2 dimension.
Regards
01-15-2024 08:23 AM
Thanks for the idea! However, these dimensions are used in a lot of other places, hence a parallel hierarchy approach wouldn't help me in this case.
01-15-2024 08:37 AM
Hi, why wouldn't help? You can set a weight of 0 so there's no impact on the sums that you have already implemented in the 1st dimension.
BR
Carlos
01-15-2024 09:22 AM
Maybe I am not understanding you correctly. I created/copied a child under Programs_Package as" Programs_Provider" and put the aggregation to 0. However, it is still not working out for me when I use a cube view. Can you please explain to me in detail how to create this hierarchy. so that it shows both the UD2s
01-15-2024 10:04 AM
Hi, could you share some images? When you use a member in another dimension, this member is shown as grey to indicate that the original dimension is elsewhere. If it's black, you're creating a new member.
Good luck!
01-15-2024 01:46 PM
@rchaturvedi27 , as per my understanding of your above question, I have tried putting across solution as below hope this helps.
If Hierarchy expansion and Suppressions are required, then Expansions and Filters Like Keep, Remove can applied on below
ABC and DEF can be replaced with your members
Column Format
Row Format
01-16-2024 09:20 AM
Thanks for the tip ! Appreciate it.
01-15-2024 06:59 PM
Hi there,
If the original question is to add 2 members that belong to the same dimension, you can create a technical member parent that has as children the 2 members you want to add. You can create this in a parallel hierarchy to avoid messing the current structure.
Another way to implement is to set up rows (or columns) for every base member to add and then use a CVR (CVC) function to make the sum of the previous 2 rows (columns)
Best regards
01-16-2024 08:50 AM
The system definitely allows multiple members in a single CubeView filter, like this: U2#MemberA, U2#MemberB. This will create two columns (or rows), one for each member. I don't understand what you're trying to do by duplicating the UD2 hierarchy in UD8.
By the way, that dynamic calc formula you posted is only printing out member names to the ErrorLog, not actually returning any value.
01-16-2024 09:20 AM - edited 01-16-2024 09:36 AM
Thanks for the tip ! Appreciate it. I am aware that OS allows multiple members in a single CubeView filter, like this: U2#MemberA, U2#MemberB. However, In my case, Programs packagae and programs provider are related to each other in some cases. Hence, I wanted to use a column in which shows related program package for a program provider in the column.
Here you can see " AL_Jazzeera ) is a part of both Programs_Package and Programs_Provider.
I wanted to show rolled up dimension TV Standard ( which is a part of Programs_Package shown against program provider cube view ( see first screenshot ).
Similary shown relevant programs_provider member against another cube view of programs_package.
01-17-2024 05:48 AM - edited 01-17-2024 06:16 AM
I have a feeling Package and Provider should have been in two different UDs, but anyway...
I'm still not entirely sure what your output should look like, maybe it would help if you created a mock in Excel with the desired final layout and showed it to us.
Things I would keep in mind:
01-17-2024 06:53 AM
Thanks! for the detailed advice. will have a look.
01-16-2024 06:38 PM
Hi Rchaturvedi,
Thank you for explaining further the issue. I think that the idea of a cube is that you have sorted data, meaning that the data cells are easily identifiable by the coordinates defined by the selected members for each dimension. In this case it seems that you have to search for a cell which has 2 different values for UD2 which is not allowed. By default, I'd try to move one of the branches to another dimension, maybe to a UDx different to UD3.
Just by curiosity, what do you expect to recover when you have as input "Programs_provider/Al_Jazzeera" x "Programs_SPP/Al_Jazzeera"?
Thank you.
BR, Carlos