If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display of String data in list

Started by AJAYC, 13 Jun 2017 07:41:28 AM

Previous topic - Next topic

AJAYC

Hi All

I have a TM1 Cube published in a package to BI. The cube's measure dimension contains both numeric and string data, eg "values" and "Comments".

The list report I am developing is using an "Account" dimension to display values and comments for each row (every account). The accounts sit under a consolidation called "All Accounts".

When I select a single account in the column and in the slicer I can see all data for the row, eg the values and any comments.

However I am interested in seeing the data for all of the members under the "All Accounts" node. So therefore I have created a data item which simply does this:

Children ( 'All Accounts')

This has been added as a new column in the list report. BUT, only the numeric data is returned.

This seems a little strange as in both cases I am wanting the numeric and string data at the account level, by account.

What causes the inconsistency choosing the individual account and when trying to show all accounts via the Children ('All Accounts') ?

Whats the best way to resolve this ?

Thanks
Ajay

New_Guy

Hi,
Option 1: Unlock the childrens node and place the comments beside the member text.
Option 2: Add another column with just the comment.
Let us know if one of the above options worked or not>
Good luck
New guy

AJAYC

#2
Thanks for your suggestions.

As a newbie around BI I didn't understand Option 1.

With Option 2, I already have the comments in separate columns.

I wasn't sure if my request was clear, so I have attached a screenshot which hopefully explains what is going on.

Thanks
Ajay

New_Guy

Hi,
Children brings only members one level down which might not bring leaf members and the description might only be at leaf level. Try descendants( [member], 999, before) and see if you get descriptions for all the members or not. And also take a look at the dimensional functions in the functions tab of the data item expressions window.
Another option is drag the whole hierarchy into the list column and select all members when prompted for root members or all members and see if you get the description for all.
And also please mask the data when posting screen shots.Not safe.

Good luck
New guy