List of Contributions

Sandeep Dhirad

Elkjøp Nordic

Contact Details

Elkjøp Nordic

My Content

1 to 20 of 50+ total

RE: Equivalent of value prompt on Dashboard: dropdown unique value filter

Posted By Sandeep Dhirad Tue May 24, 2022 06:08 AM
Found In Egroup: Cognos Analytics \ view thread
You can use this extension, and then you can set in properties if it should be single or multi selection ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: Cognos Analytics and Extensions

Posted By Sandeep Dhirad Tue April 19, 2022 07:35 AM
Found In Egroup: Cognos Analytics \ view thread
Not an answer to your question, but bringing this up again might get some IBMers to respond. I find the extension part of the product to be very fragile. As we are on cloud, we were told that we had to upgrade from 11.2.1 to 11.2.2 during the monthly maintenance. We didn't have a window to test functionality ...

RE: Report Logic

Posted By Sandeep Dhirad Tue February 08, 2022 07:52 AM
Found In Egroup: Cognos Analytics \ view thread
If you need to filter the whole query on the logic, use Patrick's excellent expression, just replace revenue with eg 1, and add the expression or data item to filters, and equal it to 1 ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: Filter result set: need advice

Posted By Sandeep Dhirad Mon November 15, 2021 02:07 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks for the suggestion Patrick, but by changing query hints, as you suggested, the filter for amount isn't applied at all/is ignored - which shows in the generated query as well is in the report output. As you can see, there's no mention of ordernumber in the query: Query sent to the database ...

RE: From model report type to report

Posted By Sandeep Dhirad Mon November 15, 2021 04:41 AM
Found In Egroup: Cognos Analytics \ view thread
Didn't really understand what the issue is. Please elaborate and add some screenshots ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

Filter result set: need advice

Posted By Sandeep Dhirad Mon November 15, 2021 04:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hello gurus. We have a relational FM model as source and need to filter the result set. The report is quite simple ||Country||Article Category||Qty sold||Revenue||No of sale orders|| The thing is that I want to se the figures for orders that have revenue value >15000 I can solve that by using ...

RE: Icon names %

Posted By Sandeep Dhirad Wed November 10, 2021 03:30 AM
Found In Egroup: Cognos Analytics \ view thread
Just guessing, as I haven't experienced this; Check the language of both users. If they aren't the same, change and see if '%' disappears. If it does, my guess is that IBM has forgotten to translate to the language in question (islandsk?). If I'm correct, create a case with support, so they can fix ...

RE: QE-DAT-0001 Token Expiry with connecting to Snowflake.

Posted By Sandeep Dhirad Mon September 20, 2021 04:33 AM
Found In Egroup: IBM Business Analytics \ view thread
Our connection string is like this, and works without any expiration issues: jdbc:snowflake://xxxxx.yyyyy.azure.snowflakecomputing.com/?warehouse=XYZ&db=ABC&CLIENT_SESSION_KEEP_ALIVE=true ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: FM: aggregate on attribute

Posted By Sandeep Dhirad Thu September 16, 2021 07:04 AM
Found In Egroup: Cognos Analytics \ view thread
Thank you to both, for clarifying. My assumption was wrong :) I solved it by writing an expression instead of using built in functionality: minimum([Field]). ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: queryValue() macro in Framework Manager

Posted By Sandeep Dhirad Wed September 15, 2021 04:53 AM
Found In Egroup: Cognos Analytics \ view thread
QueryValue() is supported, but the syntax you are using is wrong. CognosPaul has a nice intro: Take a look at https://cognospaul.com/2019/06/06/quickie-use-new-macro-function-queryvalue/ Good Luck ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: FM: aggregate on attribute

Posted By Sandeep Dhirad Tue September 14, 2021 06:04 AM
Found In Egroup: Cognos Analytics \ view thread
It is Relational. DMR doesn't support attributes in measure dimension :) ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: Manufacturing a MUN

Posted By Sandeep Dhirad Mon September 13, 2021 07:45 AM
Found In Egroup: Cognos Analytics \ view thread
Dean, to verify your MUN is generated as intended, you can create an item and add your macro to it, with a sq() around it. #sq('[Global Planning PL].[Time Month].[Time Month].[Month]->:[TMR].[Time Month].[Time Month].['+prompt('QTD ID', 'token')+']')# prompts me, I add "MACRO_FOR_DEAN" and the ...

FM: aggregate on attribute

Posted By Sandeep Dhirad Mon September 13, 2021 07:00 AM
Found In Egroup: Cognos Analytics \ view thread
Not sure if this is a bug, or I'm using it in an unintended way - my guess is it is a bug. In Framework manager: I have a date attribute in a query subject (relational model). I want to show the minimum value, but when I set the regular aggregate to minimum, It isn't applied. I have tried with setting ...

RE: IBM Cognos Analytics R7 connectivity to Snowflake data warehouse

Posted By Sandeep Dhirad Wed August 25, 2021 04:44 AM
Found In Egroup: Cognos Analytics \ view thread
We have been running Snowflake as database for the last three years. For the last year with Cognos Analytics on Cloud, but the two previous was with Cognos on prem. It works exactly as an onprem database - based on settings in cognos regarding local or database processing ------------------------------ ...

RE: CA 11.1.7 FP3 - Custom Extension FolderOpener Weird Behaviour

Posted By Sandeep Dhirad Thu August 05, 2021 08:05 AM
Found In Egroup: Cognos Analytics \ view thread
We are having the same issue. Have you heard back from support? ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: Data Module/Data set security

Posted By Sandeep Dhirad Wed May 12, 2021 02:46 AM
Found In Egroup: Cognos Analytics \ view thread
This has been implemented in data modules. Here is an explanation on how it works SecurityColumn = queryValue('[SecurityTable].[SECURITYCODE]','[SecurityTable].[UPN] = ' +sq($account.personalInfo.email))#​​ SecurityColumn is the column to be used in the data, that has the data for row level security. ...

RE: Data Module/Data set security

Posted By Sandeep Dhirad Tue May 11, 2021 10:26 AM
Found In Egroup: Cognos Analytics \ view thread
Please delete #CognosAnalyticswithWatson

RE: Data Module/Data set security

Posted By Sandeep Dhirad Mon May 10, 2021 10:18 AM
Found In Egroup: Cognos Analytics \ view thread
We have implemented row level security by adding a table filter in the data modules, using the queryValue-function (lookup functionality) //validate: 1=1 SecurityColumn = queryValue('[SecurityTable].[SECURITYCODE]','[SecurityTable].[UPN] = ' +sq($account.personalInfo.email))#​ ----------- ...

RE: Data Modules: relative date analysis - query behavior

Posted By Sandeep Dhirad Tue February 23, 2021 09:53 AM
Found In Egroup: Cognos Analytics \ view thread
I have created an idea/RFE: https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-3057 It says it is planned for future release, and if many people vote for it, maybe we will get this functionality sooner ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------

RE: Hidden dimensions in FM package and dashboards

Posted By Sandeep Dhirad Tue February 23, 2021 02:50 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks for the input Philipp. Per my understanding, PH17308 says that referring hidden elements should work in 11.1.7. Will create a case, and see what they say. ​​ ------------------------------ Sandeep Dhirad Elkjøp Nordic ------------------------------