Skip to main content
C
CI_RWise
Newcomer
March 3, 2022

How to get description of entity to appear when using a loop in a report book

  • March 3, 2022
  • 5 replies
  • 0 views

I have a member filter loop set up to cycle through the children members of a parent entity in a report book using |Loop1Variable|. I also have |Loop1Variable| in the Page Caption of the cube view for the report book. Currently, the report book shows the name of each entity in the loop. What do I do to get the description of each entity in the loop to appear on the report?

5 replies

P
PeterFu
Newcomer
March 3, 2022

Hi,

If you put the Entity description in the Report header, you can use the system parameter, |CVEntityDesc| to get the Entity description. See print screens below.

 

PeterFu_0-1646328738589.png

PeterFu_1-1646328921369.png

Peter

C
CI_RWiseAuthor
Newcomer
March 3, 2022

Peter,

This doesn't work when using a loop in a report book. I want to loop through 10 different entities for the same report using a member filter loop type in the loop definitions of the report book. To get the loop to function, you have to define your loop1variable in your change parameters. How do you tell OS to display a description here instead of the entity name? |CVEntityDesc| doesn't work when put into the Cubeview for a report book that uses a loop. 

 

CI_RWise_0-1646336552409.png

 

C
ckattookaran
Newcomer
March 3, 2022

How about you try using Loop1DisplayVariable?

C
CI_RWiseAuthor
Newcomer
March 3, 2022

Where would you put Loop1DisplayVariable? I have tried it before by putting it in the ChangePOV MemberScript of the loop as well as in the cubeview header where I want the description to appear, but no luck. 

C
ckattookaran
Newcomer
March 3, 2022

You can pick from the drop down, value, display, and index.

ckattookaran_0-1646337964656.png

Then you can go to change parameters and add parameters and what their values are going to be.

ckattookaran_1-1646338022727.png

Use these parameters in the cube view or xf doc.

Mine is an XF Doc.

ckattookaran_2-1646338089508.png

 

 

 

S
SandeepSingh
Newcomer
December 18, 2022

Hi All,

Need some help please. I have a report book to create through XFDOC in which there is a Cube View embedded. In that word doc, have a Year as a prompt (screenshot attached) through which a report will run for a particular year. What i need is, how i a can run the same cube view for multiple entities. i don't want to create CVs with hardcoded Entity and the embed it in xfdoc and then run. There must be a smart way where i can have a parameter or variable which i can pass it in the XFDOC itself and run it. Thanks for your help in advance.

 

XFDOC.PNG

T
TauseefAliKhanB
Newcomer
October 22, 2025

I have a requirement to Show the Description in the Tabs with the Member name? How can this be done?

Terms & ConditionsAccessibility statement