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

Issue creating dynamic slicer for specific day

Started by jjohnston618, 08 Jul 2021 08:36:13 AM

Previous topic - Next topic

jjohnston618

Hi,

We are trying to create a dynamic slicer that always looks at the last completed business day only.  So, if we were to hard code the slicer every day, it would be easy like this (this represents the 3rd business day)

Slicer = [Sales Cube].[Business Days].[Business Days].[Business Days1]->:[PC].[@MEMBER].[3]

However, i want this to update dynamically and fear my approach and/or syntax is wrong and cant find anything online to help with this.  I did create a dynamic measure within my query called [Dynamic Business Days] which today equals 3 (tomorrow will be 4, etc).  And when I try to use it with my slicer it fails because its a number, not s string, among other errors:

Fail Slicer =
'[Sales Cube].[Business Days].[Business Days].[Business Days1]->:[PC].[@MEMBER].['
+
'[Dynamic Business Days]'
+
']'


How can i get my slicer to dynamically input that "3", or "4" or whatever business day it is?

MFGF

Quote from: jjohnston618 on 08 Jul 2021 08:36:13 AM
Hi,

We are trying to create a dynamic slicer that always looks at the last completed business day only.  So, if we were to hard code the slicer every day, it would be easy like this (this represents the 3rd business day)

Slicer = [Sales Cube].[Business Days].[Business Days].[Business Days1]->:[PC].[@MEMBER].[3]

However, i want this to update dynamically and fear my approach and/or syntax is wrong and cant find anything online to help with this.  I did create a dynamic measure within my query called [Dynamic Business Days] which today equals 3 (tomorrow will be 4, etc).  And when I try to use it with my slicer it fails because its a number, not s string, among other errors:

Fail Slicer =
'[Sales Cube].[Business Days].[Business Days].[Business Days1]->:[PC].[@MEMBER].['
+
'[Dynamic Business Days]'
+
']'


How can i get my slicer to dynamically input that "3", or "4" or whatever business day it is?

Hi,

What is the business logic behind which day member to use? Is it the last member of the Business Days1 level? Something to do with the day of the week?

The issue with what you are trying to do is in the timing. You need to have a complete MUN (Member Unique Name) for your slicer member before sending the request to the source. The issue here is that your dynamic member is in the data source, and you can't read this without sending a request. If we can figure out how to determine the correct number outside of the data source, you could use a macro to substitute it into the MUN before the request is sent.
Alternatively, is there a filter() function that could be used to isolate the appropriate Business Days1 member - if so, this could be used as the slicer expression.

Cheers!

MF.
Meep!