go to post Peter Steiwer · Jan 17, 2018 Very cool, this should definitely help. Another good reason to contact the WRC :)
go to post Peter Steiwer · Jan 17, 2018 That is not the question. The question is about being able to configure Caché cube for example to link to the HTTPS pages, which it can not
go to post Peter Steiwer · Jan 17, 2018 Unfortunately, it does not look like this is implemented. I would suggest opening a new WRC so that your request can be logged and so you can track the status of this enhancement request
go to post Peter Steiwer · Dec 26, 2017 https://github.com/psteiwer/AOCSolutions were almost always "shove everything into an array and do the necessary work"For next year I should handle the input better and also create some method templates/code snippets
go to post Peter Steiwer · Dec 19, 2017 I just did mine state based, while one needed to wait, just flipped the state to the other
go to post Peter Steiwer · Dec 15, 2017 11 00:08:01 90 11 01:55:04 1458 0 Had to take a break between these two, but barely top 100 on the first - the second part was quite easy so if I hadn't taken a break, maybe I would have been able to get top 100 again
go to post Peter Steiwer · Dec 8, 2017 I was planning on sharing my code at the end of the event, I think it is more fair that way
go to post Peter Steiwer · Sep 8, 2017 I believe this is because you need to add a connection string to tell the terminal which instance to connect to. Please see this documentation for information on how to connect to a local instance or a remote instance
go to post Peter Steiwer · Sep 6, 2017 I am a big fan of doing this. It helps find the correct instance fast and helps prevent spending time debugging the wrong instance on accident!
go to post Peter Steiwer · Jul 14, 2017 In MDX, you need to include "on AXIS" where AXIS can be 0,1,2,rows,columns. I think it would be rare to find this text in an SQL query.Is calling %DeepSee.ResultSet.%PrepareMDX() and checking the status an option? If this succeeds, you are ready to Execute and if it does not, then you can proceed with SQL.
go to post Peter Steiwer · May 25, 2017 DeepSee has a pretty good Developer Tutorial in the Documentation. This is a very good place to start. There are also the "HoleFoods" and "Patients" cubes in the SAMPLES namespace that you can take a look at and play around with to see some of the basic features of DeepSee
go to post Peter Steiwer · May 5, 2017 List levels can be confusing because as defined, a single fact can have multiple members. This means that you may see counts higher than the total number of facts in your cube. This can be quite the surprise if you are not expecting it.Based on the complexity of these types of levels, I would not suggest using them in dimensions with other levels. There may be a particular case where you need this, but I think it would be much safer and a lot more easy to understand if the other levels were placed in different dimensions.
go to post Peter Steiwer · May 5, 2017 Hi Arutunyan,Let me know if this properly answers your question. If it does not, please consider adding an example.We can use the property FullName as an example. Some values for this may be "Gevorg,Arutunyan" or "Steiwer,Peter". You can make a dimension with a source expression using $piece to extract the Last name or the First name. In this case, you may want a single dimension with 2 levels. The first level is "Last Name" that uses the expression: $piece(%source.FullName,",",1). The second level can be called "FirstName" and it can use the expression: $piece(%source.FullName,",",2).
go to post Peter Steiwer · Apr 18, 2017 Documentation says that if you use Target=* on your print PDF control, you can "print your dashboard". This option will simply create one PDF that contains each of your widgets printed as they would normally print. So if you are looking for 1 PDF, this may be the option for you. If you want to save an exact copy of what you see on your dashboard, as Alessandro points out, the browser Print option may be best.I am not sure if you have already explored this or if you had a print control on each widget previously.
go to post Peter Steiwer · Mar 16, 2017 Hi Derrek,I suggest taking a look at the IIF Documentation. I think this is what you are looking for. Here is an example:>> WITH MEMBER [Measures].[TestIIF] As 'IIF((([Measures].[Amount Sold]>500) AND ([Measures].[Amount Sold]<3000)),[Measures].[Amount Sold],"")' SELECT {[Measures].[Amount Sold],[Measures].[TestIIF]} on 0,NON EMPTY [Product].[P1].[Product Category].Members ON 1 FROM [HOLEFOODS] Revenue TestIIF1 Candy $162.49 *2 Cereal $402.61 *3 Dairy $105.95 *4 Fruit $977.62 977.625 Pasta $1,408.68 1,408.686 Seafood $238.70 *7 Snack $4,195.20 *8 Vegetable $552.95 552.95
go to post Peter Steiwer · Mar 13, 2017 Unfortunately, from what I can tell, it does not seem like we parse the TARGET setting. This means that if you want to apply the setting to multiple Widgets, you will need to create multiple SETTINGS parameters basic_dashboard_url&SETTINGS=...;&SETTINGS=...;&SETTINGS=...;...; This being said, if you want the setting applied to ALL widgets, removing TARGET will apply the setting to all widgets. You can also set TARGET=* to apply to all widgets as well.
go to post Peter Steiwer · Mar 7, 2017 In Architect, if you select a Dimension, there will be a checkbox that says "Enable the All level for this dimension "