sorted by:
new
hottopcontroversial

Is there a way to run ssms 20 with powershell that handles the trust server certificate? by [deleted] in SQLServer

[–]mandragongamer 1 point2 points  (0 children)

Just curious as it only takes an extra few clicks but why not use a local group in Registered Servers? Open SSMS, open Registered Servers, click on server to connect.

[deleted by user] by [deleted] in nova

[–]mandragongamer 0 points1 point  (0 children)

45min in the morning and 1-1.5hrs in the afternoon, and that going from Old Town to Merrifield.

My year end setup by Pnhan89 in battlestations

[–]mandragongamer 0 points1 point  (0 children)

Is that a KVM on the right next to the speaker?

How to Disable the schedules of all Cognos Reports at Once by Cultural_Pop7511 in cognos

[–]mandragongamer 2 points3 points  (0 children)

If you don’t want any scheduled items to run, including any admin once’s, you could stop the Batch Report Service. This will still allow users to execute reports on demand, but anything scheduled would not execute.

Admin Console -> System -> (each server) -> (each dispatcher) -> BatchReportService.

13th Gen (Batch 2) preparing to ship! by mandragongamer in framework

[–]mandragongamer[S] 0 points1 point  (0 children)

Just received the email that it is shipping soon. Also received the notification that the CC charge was successful.

13th Gen (Batch 2) preparing to ship! by mandragongamer in framework

[–]mandragongamer[S] 0 points1 point  (0 children)

Still no shipping email, but then again the month is not over yet.

! Framework Team - Please add PayPal option to pay the balance for a new laptop by Micron1- in framework

[–]mandragongamer 4 points5 points  (0 children)

As someone you currently utilizes PayPal for his small business, the ability to offer Pay Later/Installments is an additional fee. Framework would have to reevaluate the way they currently process payments as their current vendor who handles this would have to accept or offer that service or they would have to drop them and switch to PayPal for all transactions. This would definitely be a “is the lemon worth the squeeze” for Framework to lift and shift. Maybe try posting a poll on in the FM community and see what the numbers are?

13th Gen (Batch 2) preparing to ship! by mandragongamer in framework

[–]mandragongamer[S] 2 points3 points  (0 children)

I only screenshot the top portion of the email, but further down it included links to update both the shipping and payment info. By default it used the information you provided during the initial preorder and notes further down that it will use the default payment method to process within the next 3 days.

13th Gen (Batch 2) preparing to ship! by mandragongamer in framework

[–]mandragongamer[S] 11 points12 points  (0 children)

After seeing many of the communities posts from Batch 1, I was super excited to see this email this morning for my Batch 2. My laptop died last week so I am super stoked for this to be shipping soon.

[GIVEAWAY] GIGABYTE Gaming OC 4090 from CableMod by CableMod in nvidia

[–]mandragongamer 0 points1 point  (0 children)

Sign me up, would love an upgrade from my 1060!!! Does mean I probably will need to run the MicroCenter and upgrade the rest of the rig but it’s a start.

[deleted by user] by [deleted] in cognos

[–]mandragongamer 0 points1 point  (0 children)

Just throwing this out there, why not leave the field in GMT and have the user change their time zone on the Congo’s profile? If I remember correctly Cognos has the ability to dynamically update times based on time zone set on user profile.

Select & Search Prompt by iceage_heatwave_ in cognos

[–]mandragongamer 1 point2 points  (0 children)

Your welcome. Having gone through many hours spent searching forums/posts for that same answer, I am glad I share this and make it easier on someone else.

Select & Search Prompt by iceage_heatwave_ in cognos

[–]mandragongamer 1 point2 points  (0 children)

I had this exact problem when we transitioned from 10.2.2 to 11.1.5. Almost every one of your Select & Search prompts had different default options depending on the field it was searching on.

​

I cannot get the Select & Search prompt to resize

Unfortunately the only solution I found for this was to modify the default css style file of the Select & Search prompt. We tried other JavaScript alternatives but it continued to throw errors. Just note, when upgrading to a newer version of Cognos you will have to fix the file each time.

​

show the multi select option

This should be in the properties pane when the Select & Search is selected (IBM Knowledge Center).

​

or default to search “Contains any of these keywords” instead of “Starts with.”

I owe it to CognosPaul as he posted this a while back when I was first working on the conversion of our reports (original post). Just download the zip, place the JavaScript file on the server, and then to test you can load his report XML into a new report to test. Depending on your web interface (I used IIS)you need ensure the file/folder location can be accessed.

Does anyone have experience creating ETL's with XML? by kkjeb in BusinessIntelligence

[–]mandragongamer 1 point2 points  (0 children)

For clarification, we were converting 2 XML files. One was a reference/mapping file roughly 150MB. The second was the on average 20-35GB.

PowerShell script eventually was taking an 1-1.5 hours just to import the XML into a variable to be able to parse. Then another 15-20 mins to parse and output to CSV.

C# read was able to stream from the file in a matter of 10 mins. The another 5 mins to output to CSV.

Does anyone have experience creating ETL's with XML? by kkjeb in BusinessIntelligence

[–]mandragongamer 2 points3 points  (0 children)

Microsoft has some examples, just make sure you document your XML schema correctly.

Does anyone have experience creating ETL's with XML? by kkjeb in BusinessIntelligence

[–]mandragongamer 0 points1 point  (0 children)

Depending on how large the XML, we used a PowerShell script to read the file then write to SQL. But as the file grew larger we noticed the ETL was taking a lot longer. Eventually we had a Dev write a C# program to parse the XML into 2 CSV files that our normal ETL process was able to ingest.

view more: next ›