How to enable Javascript

Latest Posts

Re: Compare two measures - each with their own measure filter @Dylan Wan Thanks - I'm going to give that a shot - it'll be a bit more complex ( lookups based on presentation variables ) but if I can navigate that it seems hopeful!
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 days ago
- Questions & Answers
- Reported - view
Re: Compare two measures - each with their own measure filter @Ashwin Warrier I think this will be very valuable, but this set of dashboards and insights is all built on a Fiscal Calendar so it won't line up nicely with the Gregorian calendar.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 days ago
- Questions & Answers
- Reported - view
0
Compare two measures - each with their own measure filter
I have an insight w/ several measures from different time periods ( e.g. current week sales, last week sales, current month, last month, current year, last year ) For each measure column I have the…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 4 days ago
- 5 replies
- 13
- Questions & Answers
Re: Pivot Table Column Order How much latitude do you have with schema design? There may be an easy "checkbox" way to do this in Incorta, but I don't know it ;-) Also, I haven't tried the below yet so grain of salt and all that…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 9 days ago
- 1
- Questions & Answers
- Reported - view
Re: Alerts Filter @Joe Rief It sounds like you are after burst reports. I have heard that's in the works - in the meantime you may want to surf on over and give this an upvote: https://community.incorta.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 10 days ago
- Questions & Answers
- Reported - view
Re: DBVisualizer connection to Incorta ( creds question ) @joseph. delpercio Thanks! That's where I landed, except it won't work w/ an email address for the UID - it needed the user "admin"
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 12 days ago
- 1
- Questions & Answers
- Reported - view
Re: DBVisualizer connection to Incorta ( creds question ) @Amit Kothari I did - we were in a race with support ;-) For the record I was missing: the uid ( admin ) pw I got from someone involved in setup ( not typing here!…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 13 days ago
- Questions & Answers
- Reported - view
Re: DBVisualizer connection to Incorta ( creds question ) @Amit Kothari Thanks for the response! I'm not sure I follow though - I can log into Incorta w/ my userID and PW, but that doesn't work for DbVisualizer.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 13 days ago
- Questions & Answers
- Reported - view
1
DBVisualizer connection to Incorta ( creds question )
I'm trying to connect to our Incorta Cloud environment with DBVisualizer. I grabbed the server information from "Connect External BI Tools" and can ping successfully ( <server>.incorta.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 13 days ago
- 8 replies
- 17
- 1
- Questions & Answers
- Answered
- Answered
Re: Lookup Function returns NULL in dashboard ( generated SQL works in MV ) Bah - first rule of anything to do with computers - turn it off and turn it on again ( or, in this case, bump the analytic services ). To be transparent ( and thankful @Dustin Basil ;…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Lookup Function returns NULL in dashboard ( generated SQL works in MV ) Thx - this is the SQL generated which returns the correct value in the MV... SELECT (MIN(R.Incorta_PeriodWeek.PeriodWeekEndDate)) AS "min" FROM R.Incorta_PeriodWeek WHERE (R.Incorta_PeriodWeek.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Lookup Function returns NULL in dashboard ( generated SQL works in MV )
I have a lookup function: lookup( R.Incorta_PeriodWeek.PeriodWeekEndDate, R.Incorta_PeriodWeek.PeriodWeek, $Incorta_PeriodWeek, date( '1776-07-04' ) ) In my dashboard this returns NULL ( grouped…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 10
- Questions & Answers
- Answered
- Answered
Re: Can an insight "ignore" a dashboard filter? With an offer like that ... ;-) Sure, I'd love a quick demo to help get me jump-started! I'll add a quick question here - I see I can add an optional field in the presentation variable property,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Can an insight "ignore" a dashboard filter?
I have a dashboard w/ a lot of insights. Nearly all of which I want to prompt-filter with a dashboard prompt for a reporting period. I have an insight or two which I do *not* want filtered by…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2 replies
- 15
- Questions & Answers
- Answered
- Answered
Re: Replace Zero with blank or "-" Use a conditional format with the background and text ( or number ) both white.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Rank a subset of a result set @Joe Miller DIV is the top level in this case so all departments will roll up to a single division.
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Rank a subset of a result set I'm wondering how robust an Internal Query Expression is and if I could use that with the "rank" function adding a where clause to the query. It's just a touch beyond my reach at the moment,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Key Columns in MV Tricky - if you can really have: PO PO Line ORD# 1 1.1 NULL 1 1.2 NULL 1 1.1 NULL And you source system sends an updated PO - 1 PO Line 1.1 and ORD# 987 there's no way to identify if 987 belongs to…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Rank a subset of a result set
This is an interesting use case - I have a set of departments reporting up to a division. Each department is scored on a series of metrics and given a final score *as is the division* ORG SCORE ===…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 4 replies
- 29
- Questions & Answers
Re: Key Columns in MV Echoing Dylan's question - what logic can you define to tell Incorta which ORD# should replace the NULL? My mantra is "if you can define it, you can make it happen,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Incorta Analytics view has rows when authoring, loading zero So after bouncing services I now get rows returned ( huzzah! ) but am still getting the banner showing that I need to load the views which doesn't stop me from getting data,…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Incorta Analytics view has rows when authoring, loading zero @Jeff Wilgus 1) Yep - I'll confess I didn't try that until now because it returned results in the authoring mode of creating the table, but yes, I can create an insight and return rows.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
0
Incorta Analytics view has rows when authoring, loading zero
The title sums it up. I've created a derived table w/ Incorta Analyzer. When I built it - and now when I edit it - it shows 900-some rows being displayed/returned.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- 3 replies
- 13
- Questions & Answers
- Answered
- Answered
Re: Copy a schema to another *and* move from environment 1 to environment 2 @Dylan Wan Yes - so it breaks into two things 1) ability to create a copy of an object ( ideally from table/view up through schema or business schema ) and 2) the ability to point an object ( or…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Copy a schema to another *and* move from environment 1 to environment 2 @Dustin Basil Ha! I'm with you and I advocate and follow that best practice, but the world simply will not listen to us! In this case a developer built a schema in DEV and migrated to PROD.…
- R. A. Dawson Sr
- PMsquare
- R_A_Dawson_Sr
- 1 mth ago
- Questions & Answers
- Reported - view

1 2 3 4 5 Next

Back to top

R. A. Dawson Sr

R_A_Dawson_Sr

PMsquare

Senior Consultant

United States

136
53
2

Follow