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

Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Active Report - Select all drop down list items
« Last post by dougp on 01 Jul 2022 10:02:12 am »
Maybe I missed something.  Couldn't you do the same thing by making the parameter optional and not selecting anything in the list?  If it's a matter of aggregating and showing a project name or "all projects", couldn't that be done by way of a macro?

Code: [Select]
case
  when # prompt('project','string','ALL') # = 'ALL'
    then 'All Projects'
  else [Project Name]
end
2
Reporting / Re: Active Report - Select all drop down list items
« Last post by MFGF on 30 Jun 2022 02:37:55 pm »
In order to get around the multi-page and detail list requirements I have been playing around with Drill-through definitions.   I created a report that is a basic list of items (target report) and I was able to export a csv file on the report when the hyperlink was clicked on Product portfolio (in the source report).  Success!  Popped a bottle of champagne gave a congratulations speech to my dog.  All is well in the world!
 
Next  I tried to  produce an output of only the items that made up the summarized count of the crosstab intersection.  This is where I am coming into some issues.  I did the following:

1.   Unlocked Page designed objects
2.   Checked the query and default measure that was being used
3.   Ih the Properties pane, set the Define contents property to Yes
4.   From the crosstab query, drag the measure that disappeared to the empty crosstab intersection.
5.   Click the measure in the crosstab intersection and then, in the Properties pane, click Drill-through definitions.
6.   Create the drill through definition

I was expecting to just have the 42 items that were summarized in the cross tab intersection populate in the CSV file, however what I got was the same data in the csv file that was in the link for the product portfolio. 

Should I create a cross tab in the target report?  Does every item in my crosstab query from the source report need to be in my target report as well?  The measure I used in the Crosstab was # of accounts.  I created a new data item by taking the expression of account number and changed the detail aggregation to count distinct and named that account number (Count) and then used that as my measure in my Crosstab in my source report.   

Hi,

I'm assuming the target report of the drill-through is a "regular" report (vs an active report)? Did you create prompts or filters with parameters in this report to receive the relevant items from the rows and columns in the source report?

If not, add those prompts (or filters that use parameters), then save the report. Then go back to the drill-through definition in your source report and make sure the definition is passing the correct items to fulfill the parameters in the target report.

Cheers!

MF.
3
Reporting / Re: Active Report - Select all drop down list items
« Last post by Vanaeph on 30 Jun 2022 01:46:40 pm »
In order to get around the multi-page and detail list requirements I have been playing around with Drill-through definitions.   I created a report that is a basic list of items (target report) and I was able to export a csv file on the report when the hyperlink was clicked on Product portfolio (in the source report).  Success!  Popped a bottle of champagne gave a congratulations speech to my dog.  All is well in the world!
 
Next  I tried to  produce an output of only the items that made up the summarized count of the crosstab intersection.  This is where I am coming into some issues.  I did the following:

1.   Unlocked Page designed objects
2.   Checked the query and default measure that was being used
3.   Ih the Properties pane, set the Define contents property to Yes
4.   From the crosstab query, drag the measure that disappeared to the empty crosstab intersection.
5.   Click the measure in the crosstab intersection and then, in the Properties pane, click Drill-through definitions.
6.   Create the drill through definition

I was expecting to just have the 42 items that were summarized in the cross tab intersection populate in the CSV file, however what I got was the same data in the csv file that was in the link for the product portfolio. 

Should I create a cross tab in the target report?  Does every item in my crosstab query from the source report need to be in my target report as well?  The measure I used in the Crosstab was # of accounts.  I created a new data item by taking the expression of account number and changed the detail aggregation to count distinct and named that account number (Count) and then used that as my measure in my Crosstab in my source report.     
4
Reporting / Table of content
« Last post by so10070 on 30 Jun 2022 02:53:02 am »
Is it possible to create a table of content at two levels:
* level one
   * level 2.1
   * level 2.2
   * etc
* level two
* etc
5
Reporting / Re: return all characters to the left of a dash
« Last post by M1ndbender on 28 Jun 2022 09:53:08 am »
thank you very much. This is helpful
6
Reporting / Re: return all characters to the left of a dash
« Last post by MFGF on 28 Jun 2022 09:48:37 am »
Hi there,
Is it possible to return all characters to the left of a dash? this is in Cognos Analytics 11.2 but the data is based on of a data module from a TM1 cube

data example                     would like to return
dave-supplier                      dave
ian-vendor                          ian
candace-finance                  candace
bruce-hr                             bruce

when I try to use left I get an error saying left is not supported, I have tried trim and find with no luck.

Any help would be appreciated

Hi,

If the underlying source is a TM1 cube, you are dealing with members rather than regular data items. Although the members might appear to be character strings when displayed in the report, they are actually identified by a Member Unique Name (MUN), and these are what your report is referencing (although the report displays the captions). See the post below for more details:

https://www.cognoise.com/index.php?topic=27883.0

One thing you might try is to extract the captions from your members, then maybe you could do some manipulation of these using position() and substring() functions. It all depends where in the report you are doing this and how you need to further use these results.

You can use a caption() function to extract captions, but this may or may not work for your desired scenario here.

Cheers!

MF.
7
Reporting / return all characters to the left of a dash
« Last post by M1ndbender on 28 Jun 2022 08:58:01 am »
Hi there,
Is it possible to return all characters to the left of a dash? this is in Cognos Analytics 11.2 but the data is based on of a data module from a TM1 cube

data example                     would like to return
dave-supplier                      dave
ian-vendor                          ian
candace-finance                  candace
bruce-hr                             bruce

when I try to use left I get an error saying left is not supported, I have tried trim and find with no luck.

Any help would be appreciated

8
Report Studio / Re: Conditional column hiding
« Last post by curious139 on 28 Jun 2022 08:12:10 am »
Hi,

I had the same issue and i followed the above steps and able to aggregate the rows based on selection as well

However, the columns I choose to aggregate appear as blank.

Any ideas on how to resolve this?

Thanks,
Pages: [1] 2 3 ... 10